View the report in ascending order

[newphpcoder]

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:

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

I try this 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

[dalecosp]

You shouldn't even need to specify "ASC" ... it's the default. What kind of data is in "plt_no" ... numeric, I assume?

[newphpcoder]

dalecosp;10969265 wrote:

You shouldn't even need to specify "ASC" ... it's the default. What kind of data is in "plt_no" ... numeric, I assume?

plt_no is varchar. because in contains letters with numbers

[dalecosp]

Try "order by plt_no+0, plt_no"?

[newphpcoder]

dalecosp;10969271 wrote:

Try "order by plt_no+0, plt_no"?

I tried it but nothing has change