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
