>Subject: inverse function (database,sql,query)
>
>
>hello anybody knows how to invert selected records?
>
>example :
>
>i have selected records :
>
> apple
> mangoe
> cherry
> avocado
>
>if i invert it :
>
> avocado
> cherry
> mangoe
> apple
Records do not have order unless you use ORDER BY.
If the first set of selected was produced using ORDER BY,
you can use DESC to reverse the order.
Gordon L. Burditt
hi gordon!
thanks for the fast reply...
i select the records without ORDER BY, all i want is
to reverse my selected records without using the sort parameters
(DESC or ASC).
just like reverse() function in other programming languages.
thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
