www.webdeveloper.com
Results 1 to 2 of 2

Thread: [RESOLVED] Select Order by starttime

Hybrid View

  1. #1
    Join Date
    May 2009
    Posts
    239

    resolved [RESOLVED] Select Order by starttime

    When i use the following code

    PHP Code:
    $sql="SELECT * FROM forms ORDER BY starttime"
    The result I get is the 12:00 pm displays before 9:00 am. I assume because 1 comes before 9. But I would like the Displays to show cronologically from morning to night.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,357
    Sounds like starttime is some sort of character/text field, not a time, timestamp, or datetime field. The best solution would be to convert that column to an appropriate type. If that's not possible for some reason, then you would need to cast each one to one of those types within the query (which is pretty inefficient).
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles