Re: Really Dumb Question...
| From: | CC Zona | Date: | Wed, 11 Apr 2001 20:51:59 +0000 |
| Subject: | Re: Really Dumb Question... | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8497@lists.php.net to get a copy of this message | ||
In article <00c701c0c2af$be478f40$e84ae980@usask.ca>,
Darryl.Friesen@usask.ca ("Darryl Friesen") wrote:
> > 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);
And take out the semicolon immediately after the closing parenthesis in
"LgFile text )". :-)
--
CC