RE: [PHP-DB] Problem with this query?
| From: | Dylan Barber | Date: | Tue, 03 Aug 2004 05:22:04 +0000 |
| Subject: | RE: [PHP-DB] Problem with this query? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35533@lists.php.net to get a copy of this message | ||
2.5.4 - the docs imply it does
Dylan Barber
www.codegalaxy.com - A webservices company
DotNetNuke Portal Specialists
Simple Affordable & Reliable - Web Design, and Programming
> -----Original Message-----
> From: John Holmes [mailto:holmes072000@charter.net]
> Sent: Tuesday, August 03, 2004 12:19 AM
> To: Dylan Barber
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Problem with this query?
>
> Dylan Barber wrote:
> > Okay maybe its late or something but this should work,
> however I get
> > this
> >
> > #1064 - You have an error in your SQL syntax. Check the
> manual that
> > corresponds to your MySQL server version for the right
> syntax to use
> > near 'SELECT tblVideos.PerformerID
> >
> > FROM tblVideos
> >
> > WHERE 1 =1 AND tbl
> >
> >
> >
> > Anybody got a good clue whats wrong with this SQL?
> >
> > SELECT tblPerformers.ID, tblPerformers.StageName,
> tblPics.PicName FROM
> > tblPerformers, tblPics WHERE 1 =1 AND tblPerformers.ID =
> > tblPics.PerformerID AND tblPics.Active = 'yes' AND tblPics.Type =
> > 'name' AND tblPerformers.ID IN ( SELECT UNIQUE
> tblVideos.PerformerID
> > FROM tblVideos WHERE 1 =1 AND tblVideos.Active = 'yes') ORDER BY
> > tblPics.ID DESC LIMIT 0 , 6
>
> What version of MySQL are you using? It looks like you're
> using a version that doesn't support sub selects.
>
> --
>
> John Holmes
>
> php|architect - The magazine for PHP professionals -
> php|http://www.phparch.com
>
> --
> PHP Database Mailing List (http://www.php.net/) To
> unsubscribe, visit: http://www.php.net/unsub.php
>