嗨,我
正在失去理智,我无法弄清楚这一点,请帮忙。
这是我的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 嗯?这只是为了测试吗?