Re: order by ASC

John Taylor-Johnston wrote:

Ok, I think this is a MySQl question. Take pity on me? $sql = "SELECT * FROM $db.mailinglist WHERE type IN ('Member', 'Affiliated', 'Life Member') ORDER BY rollnumber ASC"; rollnumber is a varchar(50). I need it to be a text field. ASC does not order the way I want. 1000 1001 998 999 I want it to order like this: 998 999 1000 1001 How do I trick it? I cannot think of a way in MySQL. Is there a way in PHP?

CAST it to an integer in the ORDER BY clause. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP