My table data is like that ID NAME order 1 English 0 2 Italian 1 3 Spanish 2 4 Hindi 1 5 Bengali 3 6 Tamil 2 my query I want data like this order-1,1,2,2,3,0 ID NAME order 2 Italian 1 4 Hindi 1 3 Spanish 2 6 Tamil 2 5 Bengali 3 1 English 0 Answer Try this:
Tag: sql-order-by
How to multiple withcount() columns sum and order by in laravel
I have to need to order by records based on withcount() function in laravel 6 In this code, I have two withCount() functions and I need to order By based on that two-column sum before get(). It works when order by using one column but if I use two-column then it returns an unknown column. Is it possible or no…
Get original and current prices with a subquery in MySQL with PHP
I have a table of ads and another of prices, relative to these ads. When the user modifies a price in the application, a new row is added to the prices table, which includes the price and the date the price was modified. I need to get a list with all the ads and, for each ad, the first price
Mysql: Query which orders by default and rank (pin/hold up entries?)
I have a products table which contains all my products. Those products table gets filled permanently with new products. However, I want to have the possibility to “hold up”/”pin” certain products to a place in the returned query collection. Means, I want to set something like rank_inde…
Reorder chat tabs so tabs with newest received or sent messages are on top of list
I’m working on a simple messenger. This is how the Chat table looks like: This is how the User table looks like: This is how the PinnedUser table looks like: By using this query I can display …
Queries in multiple loop and Ordering by id of last query
I have two while loops and two queries in the loops. I must order posts as DESC by its IDs. But posts loop is under another query’s loop. $follows=$db->prepare(“SELECT * FROM follows WHERE …