 |
 |
Find a programming school near you
php-db | 2001041
Date: 04/11/01
- Next message: phobo: "Re: [PHP-DB] element in the SELECT query"
- Previous message: Sharmad Naik: "[PHP-DB] element in the SELECT query"
- In reply to: Darryl Friesen: "Re: [PHP-DB] Really Dumb Question..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In article <00c701c0c2af$be478f40$e84ae980 <email protected>>,
Darryl.Friesen <email protected> ("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-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: phobo: "Re: [PHP-DB] element in the SELECT query"
- Previous message: Sharmad Naik: "[PHP-DB] element in the SELECT query"
- In reply to: Darryl Friesen: "Re: [PHP-DB] Really Dumb Question..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
