Order database results in PHP

[princeofpersia]

Hi Guys

 

I have a product page in mysql as below:

 

id        itemnumber    order_id

1        348939012    2

2        535432454    1

3        543253424    4

4        987698769    3

 

 

I need to order this in my PHP mysql_fetch_assoc by order id.

 

What I mean is I need to list them by  order_id: 1,2,3,4

 

I have used ORDER BY order_id but still it wont work,

 

any ideas?

[El Chupacodra]

How did you write the sort when it didn't work?

It's a pretty failsafe command when used right.

[princeofpersia]

$select=mysql_query("SELECT * FROM products  ORDER BY order_id");

and then while($row=mysql_fetch_assoc($select)) {}

[trq]

It should work fineWhat results are you getting? What data type is order_id?

[princeofpersia]

It just doesn't the same code works on another website, I check mysql versions, they are same. It is a varchar

[trq]

Why are you storing integers in a varchar type? That is your issue.

[princeofpersia]

I just changed it to int but still messed up