...

View Full Version : view the reort in ascending order



newphpcoder
11-25-2010, 12:56 AM
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

ac04
11-25-2010, 12:59 AM
Do you want it in order of the number ascending, or in order of the date ascending?

newphpcoder
11-25-2010, 01:08 AM
Do you want it in order of the number ascending, or in order of the date ascending?

According to plt_no.

Thank you



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum