% if ($textfield) { include "php/config.cfg.php3"; $conn=mysql_connect("$dbserver", "$dbuser", "$dbpass") or die("Can't connect to the SQL-server"); mysql_select_db("$dbname",$conn); $got_prize = 'false'; $query = "select * from PRIZE where NUMBER='$textfield'"; if($result=mysql_query($query,$conn)) { $err_str = "資料庫指令有誤 \\n\\n"; $err_str = "$err_str query Error : $query"; $valid_f=1; } if ($prize = mysql_fetch_array ($result)) { print " \n"; $got_prize = 'true'; } $query = "select * from LUCKY_PRIZE where NUMBER='$textfield'"; if($result=mysql_query($query,$conn)) { $err_str = "資料庫指令有誤 \\n\\n"; $err_str = "$err_str query Error : $query"; $valid_f=1; } if ($prize = mysql_fetch_array ($result)) { print " \n"; $got_prize = 'true'; } $query = "select * from TOP_HISTORY where NUMBER='$textfield'"; if($result=mysql_query($query,$conn)) { $err_str = "資料庫指令有誤 \\n\\n"; $err_str = "$err_str query Error : $query"; $valid_f=1; } if ($prize = mysql_fetch_array ($result)) { print " \n"; $got_prize = 'true'; } if ($got_prize == 'false') { print " \n"; } } %>