GoFuckYourself.com - Adult Webmaster Forum - View Single Post

everestcash · 02-09-2006, 06:04 AM

i was thinking, is there a way to rewrite that query using 'order by id' or 'date' instead, without using a sub query. That'll be a simpler approach.

like

select from `records` where status = 'published' order by id desc limit 0, 25;

02-09-2006, 06:04 AM
everestcash Confirmed User Join Date: Apr 2002 Posts: 2,194	i was thinking, is there a way to rewrite that query using 'order by id' or 'date' instead, without using a sub query. That'll be a simpler approach. like select from `records` where status = 'published' order by id desc limit 0, 25; __________________ Got solo girls/teen traffic? Promote our exclusive solo girl sites and boost your income!