MySQL 排序依据语句和 PHP 变量


MySQL ORDER BY statement and PHP variables

嗨,我

正在失去理智,我无法弄清楚这一点,请帮忙。

这是我的sql:

$query = " select SQL_CALC_FOUND_ROWS * from programme where 1=1    ".$_SESSION['subject_where']." ".$_SESSION['practice_where']." ".$_SESSION['key_stage_where']." ".$_SESSION['targeted_group_where']." ".$_SESSION['search_where']." " ORDER BY Rating DESC " ";`

我的MySQL选择工作正常,但我想按评级对搜索结果进行排序。 当我在变量后面插入ORDER BY Rating DESC时,我总是收到以下错误:

Error message: Parse error: syntax error, unexpected T_STRING in /home4/kenobi/public_html/programmes.php on line 23

请帮忙 - 我做错了什么?

$query = " select SQL_CALC_FOUND_ROWS * from programme where 1=1 ".$_SESSION['subject_where']." ".$_SESSION['practice_where']." ".$_SESSION['key_stage_where']." ".$_SESSION['targeted_group_where']." ".$_SESSION['search_where']." ORDER BY Rating DESC ";

你那里有那些额外的引号。不过除此之外...1 = 1 嗯?这只是为了测试吗?