- HOME >
- >
- >
（食品原材料を除く）
化粧品原材料を50音順でご覧いただけます。
50音をクリックしてください。
-
"あ", "d" =>"'^ア|^イ|^ウ|^エ|^オ'");
$pa[1] = array("t" => "か", "d" =>"'^カ|^キ|^ク|^ケ|^コ|^ガ|^ギ|^グ|^ゲ|^ゴ'");
$pa[2] = array("t" => "さ", "d" =>"'^サ|^シ|^ス|^セ|^ソ|^ザ|^ジ|^ズ|^ゼ|^ゾ'");
$pa[3] = array("t" => "た", "d" =>"'^タ|^チ|^ツ|^テ|^ト|^ダ|^ヂ|^ヅ|^デ|^ド'");
$pa[4] = array("t" => "な", "d" =>"'^ナ|^ニ|^ヌ|^ネ|^ノ'");
$pa[5] = array("t" => "は", "d" =>"'^ハ|^ヒ|^フ|^ヘ|^ホ|^バ|^ビ|^ブ|^ベ|^ボ|^パ|^ピ|^プ|^ペ|^ポ'");
$pa[6] = array("t" => "ま", "d" =>"'^マ|^ミ|^ム|^メ|^モ'");
$pa[7] = array("t" => "や", "d" =>"'^ヤ|^ユ|^ヨ'");
$pa[8] = array("t" => "ら", "d" =>"'^ラ|^リ|^ル|^レ|^ロ'");
$pa[9] = array("t" => "わ", "d" =>"'^ワ|^ヲ|^ン'");
$pa[10] = array("t" => "a-z", "d" =>"'^[a-zA-z0-9]'");
?>
- '.$row[1].' ('.$nl.') '); } print('
-
'.$pa[$i]["t"].'
');
}
?>
');
$sql = "select distinct kana_j, kigen_j
from t_origin, t_product
where t_origin.hinban = t_product.hinban
and t_origin.kana_j REGEXP ".$pa[$i]["d"]."
and t_product.seihinbunrui_cd != 6
and t_product.flg_pd_j != 0
order by t_origin.kana_j";
if(!$res = mysql_query($sql)){die($sql);}
if(mysql_num_rows($res) > 0){
print('
');
}
mysql_close($connect);
?>
- ');
while($row = mysql_fetch_row($res)){
$sqll = "select * from t_origin where kigen_j = '".$row[1]."'";
if(!$resl = mysql_query($sqll)){die($sqll);}
$nl = mysql_num_rows($resl);
mysql_free_result($resl);
print('
該当なし。
'); } print('