Only query last mysql record?

Question

I have a php script and I want it to only query the last 3 records:

At the moment it query's all the records:

$query = "SELECT postbody, postdate FROM posts ORDER BY id DESC";
$result = mysql_query($query);

How would I make it so that it only query's the last 3 records.

Thanks!

Answer 1

Use the LIMIT modifier. Change your query to



$query = "SELECT postbody, postdate FROM posts ORDER BY id DESC LIMIT 3";



Or (but this probably is less efficient) use a variable to keep track in your PHP script of how many records you have retrieved already, and just stop calling mysql_fetch_array after retrieving 3 records. You probably will only notice any performance degradation if you have a really popular website that gets many concurrent hits.



BTW they may not have mentioned it in your textbook, but you can do something like this:



list($postbody, $postdate) = mysql_fetch_array($result, MYSQL_NUM);



to assign the query results straight into scalar variables, without needing to access them through an associative array.

Answer 2

Add "LIMIT 3" to the query.

Answer 3

You won't get the job, because you're an autistic retarded manchild.