How to show particular row always at first??

[watsmyname]

Greetings,

 

I have to fetch numbers of row in ascending order. However my problem is that among these rows i want one row to appear always at top and rest in ascending order. For example, i want the row with id 17 to be appeared always on top . I know this can be achieved with two different  sql statements. First display row with id 17, and next loop through the other rows. However i want to achieve this with a single sql statement. Is it possible??

 

Thanks

Watsmyname

[OldWest]

Would you mind shedding some light on exactly why you want one specific row to be on top? Is it only row 17? Can you describe more the context and purpose of this?

[watsmyname]

thanks, well id 17 is just an example, the row to show at first depends upon id that comes from query string. well i got a solution for this

 

select * from table_name  order by field(id,'17') DESC 

[watsmyname]

well i solve it but however i ran into problem. I have to show that particular id on the top, and rest should be sorted date wise.

 

I changed the code to

 

select * from table_name  order by field(id,'17'),created_date DESC 

 

But this yielded an unpleasant result. It sorted all the rows  by "created_date" ignoring first part of sort condition.

 

And "Mark Unsolved" Button is not working as well!

[watsmyname]

Well thanks guys, i got it work

 

select * from table_name  order by field(id,'17') DESC, created_date DESC