MySQL Query problem

SELECT * from commodity where name is $keywords ORDER by rank $rank limit $pages, $rows


WHERE, ORDER, limit the three of simultaneous use should be how to platoon ah, the above sentence does not


This allows the SELECT * from commodity ORDER by rank $rank limit $pages, $rows

Reply to discussion (solution)

I know, come in and get some points.

SELECT * from Tbname ORDER BY id DESC limit 0,10

All right! That's for a minute!

New issues

"SELECT * from Subcatalog the WHERE name like '% $keywords% ' and Catalog = $catalog the ORDER by rank $rank limit $pages, $rows"


The above statement, how can be done when $catalog this value is empty, you can search for other data, now here Catalog = $catalog is empty when the list there is no thing come out

