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 <[EMAIL PROTECTED]>, 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
> >
> > --
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
