mysql - Select * from table where id = ? and order by priority -


i have database fields:

  • id (int)
  • name (text)
  • priority (int)

i want show values database id = (e.g) 13 , sort them priority. e.g: field id 13 , priority 1 first other field priority 2.

how can it?

select id,name,priority table_name id=13 order priority asc; 

Comments

Popular posts from this blog

Android : Making Listview full screen -

javascript - Parse JSON from the body of the POST -

javascript - Chrome Extension: Interacting with iframe embedded within popup -