Re: 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 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net