RE: [PHP] Create table

Here you go: <? // ////////////////////////////////////////////////////////////////// // EXAMPLE OF CREATING A MYSQL TABLE WITH PHP // // // ////////////////////////////////////////////////////////////////// // include common routines -- gives the db variables for dbhost, dbuser, dbpassword, db include 'zcommon.php'; // Connecting, selecting database $link = mysql_connect("$dbhost", "$dbuser", "$dbpassword") or die("System level error: Could not connect to database: at routine BLAH0: email $sysadminemail"); mysql_select_db("$db") or die("System level error: Could not select database: at add routine BLAH1: email $sysadminemail"); // create the insert query $query = "CREATE TABLE list ( list_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT ) "; //picked up this DIE technique from someone on the list. // Wonderful way to handle bad queries. Recommended. Sorry I can't give credit. $result=mysql_query($query) or die ('<H1 align=center><font color=red>Bad Database Request</font></H2> in :<BR>' .__FILE__ .' line '.__LINE__ .'<BR><br /><b>The query used was:</b><BR><BR> '.$query .'<BR><br /><b>MySQL says</b><BR><BR> '.mysql_error() .'<BR><BR>Email administrator for help at ' . $sysadminemail . ' for help' ); // Closing connection to the db mysql_close($link); ?> * * * * * * * * * * * * * * * * * * * * * * * * * * J. Scott Johnson PHP Consulting and Design Work * * * * * * * * * * * * * * * * * * * * * * * * * * Virtual: * * * * * * * * * * * * * * * * * * * * * * * * * * sjohnson@fuzzygroup.com http://www.fuzzygroup.com/ Yahoo IM: fuzzygroup -----Original Message----- From: Uma Shankari T. [mailto:umashankari@lantana.tenet.res.in] Sent: Wednesday, March 27, 2002 3:51 AM To: PHP Subject: [PHP] Create table Hello, Can anyone please tell me how to create a table in mysql using php code.. -Uma -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php