Re: Re: Different approach?

Jochem, > what is the context of the code you posted? ... in a function? class? part of an app? > whats its purpose? A singular, tutorial example I put together to show a basic way to connect and write if the table exists, if not create table. > why do you need to check/create the table dynamically? Newbie protection. > why do you think the way its done now is 'bad'? I'm not that skilled. Just checking with real coders. I'm more of a well-meaning academic who wants to share an idea with other teachers and show them an easy, applicable example of sending score results to a mysql server. It's part of a bigger tutorial: http://compcanlit.usherbrooke.ca/eslcafe/hotpotatoes/hot-potatoes_104.htm I'm still working on it. > >>John Taylor-Johnston wrote: > >>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); -- John Taylor-Johnston ----------------------------------------------------------------------------- °v° Bibliography of Comparative Studies in Canadian, Québec and Foreign Literatures /(_)\ Université de Sherbrooke ^ ^