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
Need Help integrating php variable into mySQL SELECT query
MYSQL SELECT
Trying to restore database
Caching Dynamic Images -- no luck
Formatting mySQL date
::e-MicroBar:: MicroBar [88x31] Ads - $100 Per Year
Database connections failes after new month
#2002 - The server is not responding (or the local MySQL ser
Pagination
Frihost PHP Account
Possible to reduce minutes from PHP?
if statement
HTTP AUTH with PHP and mySQL
Build an online dictionary by PHP/MySQL
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.