I have a form with a select box of the 12 months + one for none. It (and more) are sent to a mysql database. On another web page a list is displayed and can be sorted by date, but of course the month names are not alphabetical. I tried to assign each month a number, 01,02,03, etc in a if-elseif statement, then send it to the database but that wouldn't work.
if ($month == 'jan') { $month = '01';} elseif ($month == 'feb') {$month = '02'}; etc, so I can then sort numerically, and it will display in the correct order on the web page. I have tried various versions of the above but it will not work. I know I could use numbers instead of names for the months - but for this application that would not be appropriate. 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"; The html select ---- <td valign="bottom">Month:<br /> <select name="month"> <option value="000">None <option value="Jan">Jan <option value="Feb">Feb etc </select> -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] "There is no reason anyone would want a computer in their home." --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (They why do I have 9? Somebody help me!) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php