Posted by John Taylor-Johnston on 03/16/05 05:53

> http://dev.mysql.com/doc/mysql/en/create-table.html

Thanks. Then this looks reasonable?

Would anyone code it differently?

#################################################
$server = "localhost";
$user = "myname";
$pass = "mypass";
$db = "mydb";
$table = "demo_assignment1";

#################################################
$myconnection = mysql_connect($server,$user,$pass);

#################################################
$sql = "CREATE TABLE IF NOT EXISTS `demo_assignment1` (
`StudentNumber` varchar(8) NOT NULL default '',
`Exercise1` varchar(100) NOT NULL default '',
`Exercise2` varchar(100) NOT NULL default '',
`TimeStamp` timestamp(14) NOT NULL,
PRIMARY KEY (`TimeStamp`)
) TYPE=MyISAM COMMENT='place something here';";

mysql_select_db($db,$myconnection);
mysql_query($sql) or die(print mysql_error());


#################################################
$sql = "INSERT INTO $table
(StudentNumber,Exercise1,Exercise2) values
('$StudentNumber','$Exercise1','$Exercise2')";

mysql_select_db($db,$myconnection);
mysql_query($sql) or die(print mysql_error());

mysql_close($myconnection);

• Prev in thread: Re: [PHP] if table not exists
• Next in forum: Re: [PHP] warning & question about mysql sessions & concurrency
• Prev in forum: Re: [PHP] OT - C programming
• Thread view: if table not exists

[Reply to this message]