// MySQL 読み込み。
$dbname = "bungaku";
mysql_select_db("$id");
//テーブルがあるかどうか 0=なし 1=あり
function table_exist($dbname){
$result = mysql_call("show tables like '$dbname'");
if(!$result){return 0;}
$a = mysql_fetch_row($result);
mysql_free_result($result);
return $a;
}
$result = mysql_query("SELECT kai, nendo, myoji, namae, sakuhin, shozoku FROM $dbname WHERE sakusya='$wid' or kai='$wid' or nendo='$wid' or myoji='$wid' or sakuhin='$wid' or namae='$wid'");
$num_rows = mysql_num_rows($result);
$allkazu = $num_rows;
sub kiroku {
flock(OUT, LOCK_EX);
if (!open(OUT,">> ./datalog.csv")) { &error(); }
print OUT "$word,$kensaku\n";
chmod(0666,"./datalog.dat");
close OUT;
flock(OUT, LOCK_NB);
}
<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_row($result);