phpformgenerator
This is a discussion on phpformgenerator within the MySQL forums, part of the Database Server Software category; --> Hi; I am using phpformgenerator and it works great, but how can I make mysql to sort the databased ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 09:33 AM
| ||||
| ||||
 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      |
|
02-28-2008, 09:33 AM
| |||
| |||
| Re: phpformgenerator On 11 Nov 2006 20:32:49 -0800, jt9d@excite.com wrote: > 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 > 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 |
|
02-28-2008, 09:34 AM
| ||||
| ||||
| Re: phpformgenerator jt9d@excite.com wrote: > 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 > 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. |
 |
« Help with character sets and collation?
|
PROCEDURES and TRIGGERS - inserting into multiple tables problem »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:12 PM.
