John Taylor-Johnston wrote:
Did some googling. This worked: ORDER BY CAST(`rollnumber` AS SIGNED)What is the difference? My problem in the meanwhile must be my version of MySQL?
You could have skipped quotes altogether. The difference is that you are referencing a field name, not a string value.
Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php