Re: order by ASC

From: Date: Sun, 17 Jan 2010 05:37:17 +0000
Subject: Re: order by ASC
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-301159@lists.php.net to get a copy of this message
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

« previous php.general (#301159) next »