You will laugh. When you quote month, you don't sort date by month field. You sort by "month" - text constant being always equal. In fact you son't sort it at all!
> The sort code --- > > if ($orderby == 'month_num'): > $sql = "select * from releases order by 'month'"; > elseif ($orderby == 'month_num2'): > $sql = "select * from releases order by 'month' desc"; Try this: $sql = "select * from releases order by month"; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php