PHP Nubsauce Posted December 13, 2008 Share Posted December 13, 2008 Under my ORDER BY, ID can be a number, 1-infinite, I just want to start with number 4, then continue to query the rest, I dont care really about which order after I pull number 4 first. $links = @mysql_query("SELECT * FROM ".$mysql_pretext."_news3 LEFT JOIN ".$mysql_pretext."_news_categories_join3 ON(".$mysql_pretext."_news_categories_join3.news_id = ".$mysql_pretext."_news3.ID) WHERE ".$mysql_pretext."_news_categories_join3.category_id = '7' ORDER BY ID DESC LIMIT 10"); Any ideas? Link to comment https://forums.phpfreaks.com/topic/136768-solved-i-want-to-order-by/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.