Re: [PHP] show required row first and then other remaining rows

Hi Andrew, Thanks a lot. it really worked very well. Sanjeev On 10/26/07, Andrew Ballard <[EMAIL PROTECTED]> wrote: > > This should work: > > ORDER BY CASE WHEN id = 3 THEN 0 ELSE 1 END, name > > Andrew > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.

Re: [PHP] show required row first and then other remaining rows

This should work: ORDER BY CASE WHEN id = 3 THEN 0 ELSE 1 END, name Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] show required row first and then other remaining rows

Sanjeev N wrote: Hi, Consider the following case mysql> select *from names; ++-++ | id | name| phone | ++-++ | 1 | sanju | 984565 | | 2 | sanjeev | 997223 | | 3 | puttu | 990058 | | 4 | raju| 9448110

[PHP] show required row first and then other remaining rows

Hi, Consider the following case mysql> select *from names; ++-++ | id | name| phone | ++-++ | 1 | sanju | 984565 | | 2 | sanjeev | 997223 | | 3 | puttu | 990058 | | 4 | raju| 944811 | ++