如何订购DESC并横向显示PHP [关闭]

Question

I was wondering how I would order something DESC but then make all the results display horizontally instead of vertically.

$sql = "SELECT name WHERE id > 5 ORDER BY id DESC";

Answer 1

You can put all the names in a comma-separated list, using group_concat():

select group_concat(name order by id) as names
from t
where id > 5

You can then break out each name from the list. (And, if the comma is not the right separator, you can use the separator keyword.)