view the reort in ascending order

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:

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


I try this code

PHP:

 $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

 

you ordered by plt_no, you should order by plt_date instead:

PHP:

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

I also suggest you to sanitize the POST inputs before querying a db

 

Thank you