1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

view the reort in ascending order

Discussion in 'PHP' started by newphpcoder, Nov 25, 2010.

  1. newphpcoder

    newphpcoder New Member

    Joined:
    Sep 24, 2010
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Programmer
    Location:
    Philippines
    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
     
  2. Max2010

    Max2010 New Member

    Joined:
    Oct 14, 2010
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    0
    Home Page:
    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
     
  3. newphpcoder

    newphpcoder New Member

    Joined:
    Sep 24, 2010
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Programmer
    Location:
    Philippines
    Thank you
     

Share This Page