php字段无法排序,php – 按字段排序SQL状态异常1064

我一直在

exception 'PDOException' with message 'SQLSTATE[42000]:

Syntax error or access violation: 1064

You have an error in your SQL syntax; check the manual that corresponds to your

MySQL server version for the right syntax to use near

'(questionid, 'sfname' , 'slname' , 'school' , 'grade' , 'addr' , 'city' , 'state' at line 1'

从这个声明：

$stmt = $db->prepare('SELECT * FROM event_responses WHERE eventid= :eventid ORDER BY userid DESC, field (questionid, \''.implode("' , '", $columns1).'\')');

我回应了里面的声明,它对我来说很好看：

SELECT *

FROM event_responses

WHERE eventid= :eventid

ORDER BY userid DESC,

field (questionid, 'sfname' , 'slname' , 'school' , 'grade' , 'addr' , 'city' , 'state' , 'zip' , 'semail' , 'sphone' , 'pfname' , 'plname' , 'pemail' , 'pphone' , 'noattend' , 'regid' , 'submitDate' , 'attended' , 'regmethod')

为什么会这样？

解决方法:

你在MySQL中遇到了一个奇怪的问题：

Note

By default, there must be no whitespace between a function name and

the parenthesis following it. This helps the MySQL parser distinguish

between function calls and references to tables or columns that happen

to have the same name as a function. However, spaces around function

arguments are permitted.

删除字段后的空格,使表达式为：

SELECT *

FROM event_responses

WHERE eventid = :eventid

ORDER BY userid DESC,

field(questionid, 'sfname' , 'slname' , 'school' , 'grade' , 'addr' , 'city' , 'state' , 'zip' , 'semail' , 'sphone' , 'pfname' , 'plname' , 'pemail' , 'pphone' , 'noattend' , 'regid' , 'submitDate' , 'attended' , 'regmethod')

标签：php,mysql,sql,pdo,sql-order-by

来源： https://codeday.me/bug/20190716/1477649.html