GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Zester · 02-09-2006, 04:56 AM

What is wrong with this Sub Query:

Code:

SELECT date 
FROM  `records` 
WHERE  STATUS  =  'published' 
AND date = ( select max(date) FROM `records` )
LIMIT = 25;

it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more.

02-09-2006, 04:56 AM
Zester Confirmed User Industry Role: Join Date: Jul 2003 Posts: 5,344	SQL masters: What is wrong with this Sub Query: Code: SELECT date FROM `records` WHERE STATUS = 'published' AND date = ( select max(date) FROM `records` ) LIMIT = 25; it's suppose to spit out the date of the latest 25 articles in 'published' status and nothing more. __________________ * Mainstream ? $65 per sale * new male contraception Last edited by Zester; 02-09-2006 at 04:58 AM..