php - ORDER BY 和 WHERE mysql 和 php

Question

This code doesn't work when add order by with where.

$sel = "SELECT * FROM items ORDER BY 'item_no' WHERE mainitem_id=".$_GET['cate_id'] ;

Answer 1

$sel = "SELECT * FROM items 
        WHERE mainitem_id='".$_GET['cate_id']."' 
        ORDER BY item_no";

但请注意，您的代码容易受到 SQL 注入(inject)攻击。也请解决该问题。参见 here