Sorry wrong line 4.0.16 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@xxxxxxxxxxx] > Sent: Tuesday, August 03, 2004 12:19 AM > To: Dylan Barber > Cc: php-db@xxxxxxxxxxxxx > Subject: Re: 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
