Hi again.
I thought it would be more satisfactory if I found out for myself what MySQL
version my ISP is running so I tacked a query on to one of my forms to find
out. They are running 3.22.22. That sounds pretty old?? Could that be the
problem? It /is/ going to be a problem if it is. I am creating temp tables as
a workaround for a subQuery. There are three of them sequentially selecting a
smaller and smaller data set.
In article <[EMAIL PROTECTED]>, John Morrison wrote:
> 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]
