i can't find anything on assembling a line like this and i can't get it to work that's for sure. I'm looking to display the 9 most recent items in my database, so i call the max ID and i set the limit to nine...but, what? this is the sort of thing i figure:
PHP Code:
function MaxID( $table )
{
$q = mysql_query( "SELECT MAX(id) as maxID FROM {$table}" );
$r = mysql_fetch_assoc( $q );
return $r['maxID'];
}
$maxID = MaxID( '*table*' );
$query = mysql_query( "SELECT title FROM table *starting at* id = '{$maxID}' LIMIT 9" );
While ordering by the primary key will usually give you the correct order of last inserted rows, the rows of table aren't necessarily stored in order. So using the primary key to do this usually isn't the best idea - it makes most sense to include a "last_updated_datetime" or "created_datetime" column to use for these exact situations when you need to sort by a date value. You are not sorting by the ID - that is just an arbitrary number assigned to the row - you want to sort by some sort of time-sensitive data.
Linear Mode
