登録ジャンル一覧
");
$con = @mysql_connect("localhost","event","L523GpA");
if(!$con){
unset($con);
die();
}
$db_select = @mysql_select_db("eventdb");
mysql_query("set names utf8");
//レコードのカウント
$sql = "select count(janru_id) as cnt from board_janru where janru_id != 99 and janru_id>=1 order by janru_id asc";
$res = @mysql_query($sql);
$max[0]=mysql_fetch_array($res);
//テーブルの中身
$sql_d = "select janru_name from board_janru where janru_id != 99 and janru_id>=1 order by janru_id asc";
$res_d = @mysql_query($sql_d);
print("");
print("");
//print("番号 | ");
print("項目 | ");
print("ピン | ");
print("
");
for($i=1;$row=mysql_fetch_array($res_d);$i++){
print("");
//print("".$i." | ");
print("".$row['janru_name']." | ");
print(" | ");
print("
");
}
print("
");
mysql_free_result($res);
$close = @mysql_close($con);
if(!$close){
unset($con,$sql,$res,$max,$db_select);
die();
}
unset($con,$sql,$res,$db_select,$i);
?>