chicote Posted May 27, 2020 at 07:36 PM Report Share #618245 Posted May 27, 2020 at 07:36 PM (edited) Olá, Alguem sabe que modificação devo fazer à seguinte query, deforma a que os registos com o room_id 1 e 2 da tabela boom_rooms fiquem sempre no topo? Obrigado. $rooms = $mysqli->query(" SELECT *, ( SELECT Count(boom_users.user_id) FROM boom_users Where boom_users.user_roomid = boom_rooms.room_id AND last_action > '$check_action' AND user_status != 6 ) as room_count FROM boom_rooms WHERE ORDER BY room_count DESC, room_id ASC"); Edited May 27, 2020 at 07:37 PM by chicote Editado para acrescentar informação Link to comment Share on other sites More sharing options...
M6 Posted May 28, 2020 at 09:03 AM Report Share #618256 Posted May 28, 2020 at 09:03 AM Colocas o room_id à cabeça do order by. 10 REM Generation 48K! 20 INPUT "URL:", A$ 30 IF A$(1 TO 4) = "HTTP" THEN PRINT "400 Bad Request": GOTO 50 40 PRINT "404 Not Found" 50 PRINT "./M6 @ Portugal a Programar." Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now