Re: Re: Different approach?

[Jochem Maas <jochem@xxxxxxxxxxxxx>]

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);

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php