[SOLVED] Ordering problems

[Noggin]

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

[d22552000]

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

[Noggin]

thanks a bunch, worked a treat

[d22552000]

your welcome .