这行代码
$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";