Just to try to create a database name my_database and create a table but ... database created, table isn't created ???
<html><body><?php$connect = mysql_connect("localhost","root","");if (!$connect) { die('Could not connect:'.mysql_error()); }if (mysql_query("CREATE DATABASE my_database",$connect)) { echo "Database created"; }else { echo "Error :".mysql_error(); };mysql_select_db("my_database", $connect);$sql = "CREATE TABLE Person(Name varchar(15),Infor varchar(15),)";mysql_query($sql,$connect);// Suppose insert some infomysql_query("INSERT INTO Person (Name,Infor) VALUE ('a','boy')");mysql_query("INSERT INTO Person (Name,Infor) VALUE ('b','girl')");// We get// ------------------// | Name | Infor |// | a | boy |// | b | girl |// ------------------// a,b live in drop down list $result = mysql_query("SELECT Name FROM Person");echo "<form>";echo "<select name='theName'>";while ($theArray = mysql_fetch_array($result)) { echo "<option value=' ".$theArray['Name']." '>".$theArray['Name']."</option>"; }echo "</select>";echo "</form>";?><hr/></body></html>