Good day!
I have a mysql_query code to sleect the date from the database and my problem is the output is not in ascending order. Here is my code:

PHP Code:

 $query = "SELECT plt_no FROM plt_transact WHERE plt_date BETWEEN '" . $_POST["from_date"] . "' AND '" . $_POST["to_date"] . "' "; 


I try this code

PHP Code:

 $query = "SELECT plt_no FROM plt_transact WHERE plt_date BETWEEN '" . $_POST["from_date"] . "' AND '" . $_POST["to_date"] . "' ORDER BY plt_no ASC "; 


But it did not work...where i can put the code for Asc.
Thank you

I thought it was ASC by default...

Maybe you mean descending order, try DESC and you'll probably have the result you want

Originally Posted by Mime

I thought it was ASC by default...

Maybe you mean descending order, try DESC and you'll probably have the result you want ;)

My scenario no is the plt_no that was viewed was listed according on the list in the database which is not in ascending orders.I want it that when I query the report it appear in ascending order