[SOLVED] SELECT and ORDER BY ?

[Greaser9780]

I want to select name from my table I am trying to get a result that has the lowest activate # and the lowest teamid

Tried this but I don't know how to word it.

 

$sql1 =mysql_query("SELECT name FROM `teams` ORDER BY activate,teamid ASC LIMIT 1");

 

[mbtaylor]

$sql1 =mysql_query("SELECT name FROM `teams` ORDER BY activate DESC, teamid DESC LIMIT 1");

 

ASC is ascending, DESC descdending. So if you sort by DESC then the lowest one should be first.

[Greaser9780]

TYVM

 

[mbtaylor]

You might want to read up on the mysql min function too. You can select min or max value from a db using something like:

 

SELECT min(userID) from site_users;