php mysql按DESC排序

Question

我有像下面这样的api代码，在最新的它显示根据我的要求，但对于cid和aid，我需要相同的最新(必须显示最近作为第一)。我的代码如下所示，谢谢

<?php include("includes/connection.php");

mysql_query("SET NAMES 'utf8'");

if(isset($_GET['language_id']))
{ 
    $query="SELECT cid,category_name,category_image FROM tbl_category WHERE lid='".$_GET['language_id']."'";

}
else if(isset($_GET['cat_id']))
{

    $cat_id=$_GET['cat_id'];        

        $query="SELECT * FROM tbl_quotes
    LEFT JOIN tbl_category ON tbl_quotes.cat_id= tbl_category.cid 
    where tbl_quotes.cat_id='".$cat_id."'";

}
else if(isset($_GET['latest']))
{
    $limit=$_GET['latest'];     
    $query="SELECT * FROM tbl_quotes
    LEFT JOIN tbl_category ON tbl_quotes.cat_id= tbl_category.cid 
    ORDER BY tbl_quotes.id DESC LIMIT $limit";
}
else if(isset($_GET['home_banner']))
{

    $query="SELECT app_name,app_url,app_image FROM tbl_banner";     

}
else if(isset($_GET['about_app']))
{

    $query="SELECT app_name,app_logo,app_email,app_website,app_description FROM tbl_settings";      

}
else
{

    $query="SELECT id,language_name FROM tbl_language";


}
$resouter = mysql_query($query);

$set = array();

$total_records = mysql_num_rows($resouter);
if($total_records >= 1){

  while ($link = mysql_fetch_array($resouter, MYSQL_ASSOC)){

    $set['Quotes'][] = $link;
  }
}
else
{
    $set['Quotes'][] = null;
}
 header( 'Content-Type: application/json; charset=utf-8' );
 echo $val= str_replace('\\/', '/', json_encode($set));

对此进行了实验性的修改，但无济于事

else if(isset($_GET['cat_id']))
{

    $cat_id=$_GET['cat_id'];        

        $query="SELECT * FROM tbl_quotes
    LEFT JOIN tbl_category ON tbl_quotes.cat_id= tbl_category.cid 
    where tbl_quotes.cat_id='".$cat_id."'";

}

试试这个也成功了吗？php mysql sort by date (Recent)

这是链接接口/api.php?cat_id=1

Answer 1

当您使用SELECT语句查询表中的数据时，结果集不会按任何顺序排序。要对结果集进行排序，请使用ORDER BY

就像这样：

ORDER BY column1 [ASC|DESC]

如下所示，根据它修改代码：

$query="SELECT * FROM tbl_quotes
    LEFT JOIN tbl_category ON tbl_quotes.cat_id= tbl_category.cid 
    ORDER BY tbl_quotes.id DESC,date DESC LIMIT $limit";

Answer 2

谢谢你，我试过了，而且成功了

else if(isset($_GET['cat_id']))


$cat_id=$_GET['cat_id'];        

    $query="SELECT * FROM tbl_quotes
LEFT JOIN tbl_category ON tbl_quotes.cat_id= tbl_category.cid 
where tbl_quotes.cat_id='".$cat_id."' order by cid DESC";