Re: FN-FORUM: PHP/MySQL question

date posted 10th August 2003 15:58

Hi John,

You haven't specified which columns to copy from the T_Members table, so
I've got a feeling that's where your syntax error is coming from. Try this
instead...

CREATE TEMPORARY TABLE T_Temp SELECT * FROM T_Members;

HTH,

Regards,

Steve

----- Original Message -----
From: "John Anderson" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, August 10, 2003 3:37 PM
Subject: FN-FORUM: PHP/MySQL question


>
> 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
>
>
>
> ==========
> fido.net are pleased to sponsor these Freelancers messages. For all
> your web hosting needs check out http://www.fido.net/ with hosting
> packages starting from just £46.95 a year including VAT.
> Free 0871 Fax2Email numbers also available online!
> http://www.fido.net/ - the internet made simple! - 0800 1072 666
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>