Noggin Posted August 13, 2007 Share Posted August 13, 2007 To be honest, I'm not the best at PHP, although I know enough to get by.. I have been creating a website called Noggin Animations : nogginanimations.gm-ark.co.uk I have a comics section, and each comic is given a "series name" most of the comics are in the "drawings" series, although some are in other series. At the moment I am listing them with this code: $result3 = mysql_query("SELECT id, title, img_path, date, rating, rates, views, series, mature, mature_why FROM comics ORDER BY series DESC LIMIT $start, $number ") or die(mysql_error()); while($r3 = mysql_fetch_array($result3)) { blah.. blah.. so PHP is sorting the comics by the series name (I assume it's alphabeical) However "Drawings" comes first and "Death for a week" comes second, I'd like to reverse this so that "drawings" is at the bottom if you get what I mean, please do reply -Noggin Link to comment https://forums.phpfreaks.com/topic/64660-solved-ordering-problems/ Share on other sites More sharing options...
d22552000 Posted August 13, 2007 Share Posted August 13, 2007 the ordering is handled by MYSQL and not PHP. here is a sample of what I think you want.. ORDER BY `*name here*` ASC at that to the end of your mysql SELECT statement. if its upside down use DESC instead of ASC Link to comment https://forums.phpfreaks.com/topic/64660-solved-ordering-problems/#findComment-322392 Share on other sites More sharing options...
Noggin Posted August 13, 2007 Author Share Posted August 13, 2007 thanks a bunch, worked a treat Link to comment https://forums.phpfreaks.com/topic/64660-solved-ordering-problems/#findComment-322415 Share on other sites More sharing options...
d22552000 Posted August 13, 2007 Share Posted August 13, 2007 your welcome . Link to comment https://forums.phpfreaks.com/topic/64660-solved-ordering-problems/#findComment-322421 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.