Ordering From DB

[forumnz]

Alright. If I have a db for an auction site and I want to display the auctions closing soonest, how do I do this?

I know how to code it, just the theory behind it?

 

Thanks a lot,

Sam.

[GingerRobot]

Well, presumably you have an ending time for each item in the database? You'd then simply order by this value:

 

<?php
$sql = mysql_query("SELECT * FROM `yourtable` WHERE `somefield`='somevalue' ORDER BY `ending` DESC") or die(mysql_error());
?>