php - MySQL日期格式排序错误

Question

排序查询的 desc 或 asc 日期失败:(

我应该如何进行 mSQL 查询？

请问您能帮忙吗？

$tours = mysql_query("SELECT * FROM tours WHERE tour_category_id='".$tour_category_id[category_id]."' AND tour_status='Aktif' ORDER BY kayit_tarihi DESC ");

Answer 1

$tours = mysql_query("SELECT * 
                      FROM tours 
                      WHERE tour_category_id='".$tour_category_id[category_id]."' 
                        AND tour_status='Aktif' 
                      ORDER BY tour_category_id DESC ");