view the reort in ascending order

newphpcoder's Avatar, Join Date: Sep 2010
Ambitious contributor
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
Max2010's Avatar, Join Date: Oct 2010
Go4Expert Member
you ordered by plt_no, you should order by plt_date instead:

PHP Code:
$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
newphpcoder's Avatar, Join Date: Sep 2010
Ambitious contributor
Quote:
Originally Posted by Max2010 View Post
you ordered by plt_no, you should order by plt_date instead:

PHP Code:
$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