SQL Error - create temporary table
| From: | John Morrison | Date: | Tue, 01 May 2001 22:14:22 +0000 |
| Subject: | SQL Error - create temporary table | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-7188@lists.php.net to get a copy of this message | ||
Hi
I have cobbled together my first PHP/MySQL site which
checks out OK on "localhost" (a WinMe/Xitami PC). But I
just uploaded it to my ISP and I'm getting SQL Error
reports when trying to create temp tables.
SQL Error near "create temporary table tmptable select
p.pic_id, title from picture as p, keycode_link as k where
p.pic_id = k.pic_id and k.label_code = 1 and k.keyword_code
= 5";
These temp table commands work OK on my setup (MySQL
3.23.30) and I haven't yet figured out what is going wrong.
John Morrison