Sorting reults

[chaitanyajakhad]

Hi
Is there any way to sort results on particular field.
i.e. I am using $result = mysql_query($query);

Is there any php function which sorts $result opn particular number of field.

😉

Regards,
Chaitanya

[tomhath]

Do you know how to use an "ORDER BY" clause in the SQL statement that was run as the query? I suspect that's what you want.

select * from myTable ORDER BY someField

[chaitanyajakhad]

Hi,

Yes I know. But I will have to query every time and have to lock table every time. That's what I want to avoid.
Regards,

Chaitanya