php - 将 ORDER 添加到 SELECT 请求

Question

我正在尝试对我的结果进行排序，但我收到了一个 TString 错误。有人可以告诉我在哪里或如何添加 ORDER BY date DESC, paymentamount DESC 到这个:

$sql = "SELECT * FROM `Carriers` WHERE fromzip >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_loadtype;

这是我尝试过的方法，但它不允许我:

  $sql = "SELECT * FROM `Carriers` WHERE fromzip >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_loadtype ORDER BY date DESC, paymentamount DESC;

Answer 1

试试这个..

$sql = "SELECT * FROM `Carriers` WHERE fromzip >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_loadtype." ORDER BY date DESC, paymentamount DESC";

您需要使用 (.) 将字符串值拼凑在一起。然后你还没有用引号打开字符串......

$search_loadtype ORDER BY

成为

$search_loadtype." ORDER BY