Re: SQL Error - create temporary table

Thanks for your reply Tom. I will contact my ISP, although I guess I must have create table rights because I created the permanent db tables OK. I have been browsing through the HTML MySQL manual and found, under "F MySQL change history/F.2.3 Changes in release 3.23.28", the following entry :- "Fixed a fatal bug in CREATE TEMPORARY TABLE ... SELECT .... " I always suspect my own code first when something doesn't work but I am wondering now if that bug may be the culprit? I will phone my ISP now. Cheers John In article <3AEFC99D.6E8E876A@st.com>, Tom Mathews wrote: > Subject: Re: [PHP-WIN] SQL Error - create temporary table > > Check with your ISP what access rights you have to the MySQL db - if you > don't have create table rights, then you won't be able to crete temporary > tables either. > > Tom > > John Morrison wrote: > > > 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 > > > > --