Tables Next to Each Other

[Warptweet]

I use this code to make a table with two rows, and four columns, all together.

 

<tr>
<td>top</td>
<td>top</td>
<td>top</td>
<td>top</td>
</tr>
<tr>
<td>bottom</td>
<td>bottom</td>
<td>bottom</td>
<td>bottom</td>
</tr>

 

How would I make it so that for each column, it displays one of the 4 most recent rows in my database? The most recent rows in my database can be determined because the row with the highest id (AUTO_INCREMENT) is the newest one.

 

I need to select the most recent 4, and display the most recent four on those tables.

For "top", I need it to display " . $row['upload_preview'] . " and for the "bottom" I need it to display " . $row['upload_name'] . "

 

Any ideas how to accomplish this? Thanks for any help!

[rcorlew]

$sql = mysql_query("Select * FROM tablename ORDER BY id DESC LIMIT 4");

[Warptweet]

I know that of course, but how will the website know that one of the columns needs to display the second most recent row? Third most recent row? Fourth most recent row?

[rcorlew]

Thats what the LIMIT 4 is. As long as your id row is set to autoincremint that will work wonders.

 

It will pull the last 4 rows of data which will be the newest 4 rows.