RE: Problem with this query?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux