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]

Reply via email to