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