Professional Web Applications Themes

phpformgenerator - MySQL

Hi; I am using phpformgenerator and it works great, but how can I make mysql to sort the databased on dates. I need to make sure that the latest date is on top of the page. Thanks M.J DATE FLIGHT NUMBER TAIL NUMBER GATE DELAY LOG GEN RECALL TIME...

  1. #1

    Default phpformgenerator

    Hi;
    I am using phpformgenerator and it works great, but how can I make
    mysql to sort the databased on dates. I need to make sure that the
    latest date is on top of the page.
    Thanks
    M.J


    DATE
    FLIGHT NUMBER
    TAIL NUMBER
    GATE
    DELAY
    LOG GEN
    RECALL TIME

    jt9d@excite.com Guest

  2. #2

    Default Re: phpformgenerator

    On 11 Nov 2006 20:32:49 -0800, com wrote: 

    order by descending then.

    --
    59. I will never build a sentient computer smarter than I am.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  3. #3

    Default Re: phpformgenerator

    com wrote:
     

    first of all, I certainly hope that your field names don't include spaces. That
    can be very nasty if you ever decide to move it to a real database engine.

    select col1,col2... from table <where clause> order by date desc;


    --
    Michael Austin.
    Michael Guest

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139