FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


MySQL Select





minik
I want to select some data from database but instead of displaying it as:
1
2
3

I want it

3
2
1

Is it possible to select it backwards?
MrBlueSky
You can use ORDER BY ... DESC.

For example:

Code:

SELECT name, birth FROM pet ORDER BY birth DESC;


See: http://dev.mysql.com/doc/refman/4.1/en/sorting-rows.html
Related topics
HTTP AUTH with PHP and mySQL
Build an online dictionary by PHP/MySQL
Trying to restore database
Need Help integrating php variable into mySQL SELECT query
Caching Dynamic Images -- no luck
Formatting mySQL date
::e-MicroBar:: MicroBar [88x31] Ads - $100 Per Year
Pagination
Database connections failes after new month
MYSQL SELECT
#2002 - The server is not responding (or the local MySQL ser
Frihost PHP Account
Possible to reduce minutes from PHP?
if statement
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.