346257592 发表于 2010-5-18 15:59:28

sql语句怎么执行

语句$sql="select id,thumb,state,title,trade,retail,price from shop_list where 1=1order by CASE `state` when '3' then '-4' when '0' then '-3' when '2' then '-2' when '1' then '-1' else `state` end asc";
请问这条语句怎么执行?并且还要有分页   25个一页

请帮忙看看谢谢各位了
页: [1]
查看完整版本: sql语句怎么执行