6 replies to this topic

[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

[Orjan]

it looks correct, do you get an error message, or is it not sorted correctly? what kind of field is plt_no ?

[newphpcoder]

Orjan said:

it looks correct, do you get an error message, or is it not sorted correctly? what kind of field is plt_no ?

I don't get any error mes. plt_no is varchar

[Orjan]

ah, varchar, then it sorts litteraly, so it sorts 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20. it needs to be numerical (int) to sort correctly as fas as I know.

what kind of data does plt_no contain?

[newphpcoder]

plt_no is varchar

[Orjan]

yes, so you said, but can you give examples of the physical data to be stored there?

[newphpcoder]

Orjan said:

yes, so you said, but can you give examples of the physical data to be stored there?

Thank you for your help..i resolved this issue or porblem. I'm wrong in adding code for ASC.