$sql0 ="CREATE TABLE table_name (
No int(5) NOT NULL auto_increment,
Category varchar(50) NOT NULL default '',
IP varchar(20) NOT NULL default '',
Date datetime default NULL,
name varchar(30) NOT NULL default '',
surname varchar(30) NOT NULL default '',
name_en varchar(30) NOT NULL default '',
surname_en varchar(30) NOT NULL default '',
position varchar(50) NOT NULL default '',
phone varchar(20) NOT NULL default '',
mobile varchar(20) NOT NULL default '',
pwd varchar(20) NOT NULL default '',
email varchar(100) NOT NULL default '',
school varchar(100) NOT NULL default '',
sch_phone varchar(20) NOT NULL default '',
address varchar(200) NOT NULL default '',
url varchar(100) NOT NULL default '',
start_range varchar(30) NOT NULL default '',
end_range varchar(30) NOT NULL default '',
money_sup varchar(30) NOT NULL default '',
comment text NOT NULL,
account varchar(4) NULL default '',
PRIMARY KEY (No)
) ";
$result0 = mysql_db_query($dbname,$sql0);
if($result0!=0 && $result1!=0 && $result2!=0 && $result3!=0) {
echo "<center>";
echo "<table width=60% border=1 bordercolor=#ff69b4 bgcolor=#f0ffff cellpadding=2 cellspacing=0>";
echo "<tr><td align=center>";
echo "<font size=2 face='MS Sans Serif'>";
echo "<font size=3 color=red><b>ได้สร้างฐานข้อมูลแล้ว</b></font><br><br>";
echo "<font color=blue>webboard_ans , webboard_data , webboard_member</font>";
echo "</font></td></tr>";
exit();
}
else {
echo "<center>";
echo "<table width=60% border=1 bordercolor=#ff69b4 bgcolor=#f0ffff cellpadding=2 cellspacing=0>";
echo "<tr><td align=center>";
echo "<font size=2 face='MS Sans Serif'>";
echo "มีข้อผิดพลาดที่ระบบ<br><br>";
//echo "กรุณาแจ้ง <font color=blue>admin</font> ให้ตรวจสอบด้วยครับ";
echo "</font></td></tr>";
echo "</tr></table>";
echo "</center>";
exit();
}
?>
</body>
</html>