FN-FORUM: PHP/MySQL question

date posted 10th August 2003 15:09

And how is everyone on this hot and sunny Sunday afternoon. I can hear the
lager call my name, but like a good boy, I have to earn it first. (And if
anyone can help, I'll have one for you, too!)

Anyway...

I'm trying to use the CREATE [TEMPORARY] TABLE command in MySQL in a PHP
file, but I keep getting a parsing error.

>CREATE TABLE T_Temp SELECT FROM T_Members;

T_Members exists in the database, and I'm pretty certain of the syntax. The
db host is using MySQL 4.0.1, so I shouldn't have any problems with creating
the table from a PHP file. I'm connecting okay to the database, as well as
the table itself.

So, whassup?

John Anderson
Soaring Penguin