我正在尝试为我的自动建议功能区分一列。这是我现在的查询:
$result=mysql_query("SELECT * FROM users WHERE firstname LIKE '%".mysql_real_escape_string($_GET['chars'])."%' ORDER BY firstname LIMIT 0, 10",$con) or die(mysql_error());
不知何故,只是在select后添加'DISTINCT firstname'不起作用。(Javascript给出一个错误。)查询中的*是麻烦制造者,我想,不知道确切的原因…
请协助编写正确的查询!:)
Thanks in advance
你可以用"group by firstname"代替:
$result=mysql_query("
SELECT * FROM users
WHERE firstname LIKE '%".mysql_real_escape_string($_GET['chars'])."%'
GROUP BY firstname ASC
ORDER BY firstname
LIMIT 0, 10",$con)
or die(mysql_error());