[SOLVED] Output Latest Three Records

[chordsoflife]

I'm having trouble figuring out how to output only the latest three records. I have it in the order I want, and I'm thinking what I'm looking for is a do while loop, but how would I write something like that? How can I store the primary key in a variable during the loop to use it in the while? Wrong approach?

 

Any help.. please  ???

[btherl]

Can you show us your current code?

[chordsoflife]

Sure thing:

 

	   $sql = "SELECT * FROM updates ORDER BY update_id DESC;";  
		  
	   $sql_result = mysql_query($sql,$connect)  
			or die(mysql_error());

		while ($row = mysql_fetch_array($sql_result)) {  
		extract($row);
			echo "<div id=\"containerPost\">
				  <h1>" . $update_title . "</h1>
				  <h2>Posted on " . $update_date . "</h2>
				  <p>" . $update_content . "</p>
				  </div>";
		}

[corbin]

http://php.about.com/od/mysqlcommands/g/Limit_sql.htm

[secoxxx]

SELECT * FROM updates ORDER BY update_id DESC LIMIT 0,3

 

 

 

For the last 3 records in the db

[chordsoflife]

Wow, this stuff is just so much easier than I expected 

 

Thanks, guys!