The best method will be to adda TIMESTAMP. But if you are sure that no record gets DELETEd you may use the following procedure.
CREATE a temporary Table to store the records you want to use. That temp table needs to have a key or ID. SELECT from that temp table and order using that ID. But I will recommend using a TIMESTAMP to avoid all these "acrobaties". Thanks Emery ----- Original Message ----- From: "dorilys" <[EMAIL PROTECTED]> To: "'Roger Baklund'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 19, 2003 03:01 Subject: RE : select in inverse order > Hi, > > > If your table has a primary key or unique integer key you can order > > descending using the keyword "_ROWID" like this: > > > > SELECT * FROM table WHERE NUMERO='248' ORDER BY _ROWID DESC; > > > > I just tried your solution but unfortunately I got an error > > My table have no key > > In fact my problem is it. > The users insert records, > I list the records at the end of the page, > > Like this > > Formular for input new recors > > First record > Second record > Third record > > but It's better if I can succeed to invert the order > > Formular for input new recors > > Third record > Second record > First record > > With this solution, my users avoid to scroll the page for checking the > last input. > > I prefer modify the syntax of the SELECT because it's the same PHP page > (by include) who control all my tables (+ ou - 100 tables). > Inserting a autoincrementing primary key in all tables represent a long > work and a waste of place, but if I can't find a solution by syntax,.... > I have to do that :-( > > Thanks a lot, Roger for your answer and for your help. > Dorilys > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]