order-by

zbsbpyhn 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(297)

我想用order by语句提供我的top结果。

$sql_ins = "select user_first_name, user_last_name, user_id from user 
            INNER JOIN xyz on user_id=s_id 
            where (s_id='".$_SESSION['user']."' OR r_id='".$_SESSION['user']."')
              AND user_id!='".$_SESSION['user']."' group by user_id

            UNION

            SELECT user_first_name, user_last_name, user_id from user 
            INNER JOIN xyz on user_id=r_id 
            WHERE (r_id='".$_SESSION['user']."' OR s_id='".$_SESSION['user']."')
              AND user_id!='".$_SESSION['user']."' 

            GROUP BY user_id";

我想按order by id desc获取输出，但输出是一个错误。

mysql union php sql-order-by

来源：https://stackoverflow.com/questions/51477132/order-by-with-union-in-php

1条答案

按热度按时间

xsuvu9jc1#

使用这个查询它对我有用。。。。

SELECT * 
FROM (SELECT content_update.id as id, 
             content_update.course_id as course_id, 
             content_update.status as status, 
             content_update.title as title, 
             content_update.img_src as img, 
             content_update.entry_date as entry_date 
      FROM content_update 

      UNION ALL 

      SELECT video_update.id as id, 
             video_update.course_id as course_id, 
             video_update.status as status,
             video_update.title as title, 
             video_update.video_link as img, 
             video_update.entry_date as entry_date 
      FROM video_update ) results 

ORDER BY entry_date DESC

赞(0）回复(0）举报 2021-06-21

我来回答

order-by

1条答案

相关问题

热门标签

最新问答