Re: Really Dumb Question...

From: Date: Wed, 11 Apr 2001 17:49:22 +0000
Subject: Re: Really Dumb Question...
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-8493@lists.php.net to get a copy of this message
> How do I create a table within my PHP? Heres what I currently have, but I > keep getting parse error on the "create" line... Because create is not a valid PHP command. You have to assign the create statement to a string, _then_ pass the string to mysql_query: $sql = "create table $propTable ( ID int not null auto_increment primary key, TourName tinytext, TourTitle tinytext, ViewTitle tinytext, TourNum tinyint not null, Applet tinyint not null, Desc text, TourPath text, SmFile text, LgFile text ); "; $result = mysql_query($sql); - Darryl ---------------------------------------------------------------------- Darryl Friesen, B.Sc., Programmer/Analyst Darryl.Friesen@usask.ca Education & Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan ---------------------------------------------------------------------- "Go not to the Elves for counsel, for they will say both no and yes"

« previous php.db (#8493) next »