语法错误(MySQL、PHP)


Wrong syntax (MySQL, PHP)

这行代码

$SQL = "SELECT * FROM stats ORDER BY Team WHERE Team='$teamval'";

返回以下MySQL错误:

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 'WHERE Team='OTT''
at line 1

我找不出语法有什么问题,它出了什么问题?

ORDER BY子句必须出现在WHERE子句之后。因此,您的查询应该是:

SELECT * FROM stats WHERE Team='$teamval' ORDER BY Team

您已经使用了使用order by before where子句的正确语法,如果您在查询中使用了limit,则应在查询结束时使用order by,然后将order by置于limit之前

SELECT * FROM stats  WHERE Team='$teamval' ORDER BY Team

替换:

$SQL="SELECT * FROM stats WHERE Team='$teamval' ORDER BY Team";