php mysql ascdesc命令

php mysql asc / desc命令

您

GROUP BY bookslot.b_ref

正在对记录进行分组，因此每种情况下您只会看到最后一次。

尝试使用

SELECt date, time, MIN(bookslot.id_timeslot)FROM bookslot  LEFT JOIN timeslot ON bookslot.id_timeslot = timeslot.id_timeslot   WHERe bookslot.status = 1 GROUP BY bookslot.b_ref  ORDER BY bookslot.date ASC, bookslot.id_timeslot ASC LIMIT 20