Posted by Jochem Maas on 10/18/01 11:11

John Taylor-Johnston wrote:
> Sorry to bother. I was hoping for inspiration. The code works. I wonder if there is a cleaner way?

what is the context of the code you posted? ...
in a function? class? part of an app? whats its purpose?

why do you need to check/create the table dynamically?
why do you think the way its done now is 'bad'?

rgds, Jochem

>>John Taylor-Johnston wrote:
>>Hi,
>>
>>I've read:
>>
>>
>>>http://dev.mysql.com/doc/mysql/en/create-table.html
>>
>>Would anyone code/approach this 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);
>

[Back to original message]