Hi.

I've got another PHP problem, this time It's sorta to do with a MySQL database.

I've got a link the database working, no problem. The only problem is, I only want it to display the last three rows of information. I know there is a way to do this, but as I'm reasonably new to PHP, it's sorta pushing my limits really.

If someone could help, I'd be really happy!

Okay, sounds like you want a mysql query run through php that only grabs "row1", "row2" and "row3".

PHP Code:

<?
$result = mysql_query("SELECT row1, row2, row3 FROM table_name WHERE id='1'");

if (!$result)
{
     echo("<p>Unable to locate query results at this time.</p>");
     exit();
}
?>

I think you are close lippy! It needs to display the last 3 rows available (it's for a news page). So everytime the user updates it, it will remove the oldest news and will replace it with the new.

ie

2004 - 12 - 02

blabla

2004 - 11 - 02

blablabla

2004 - 10 - 02

zzzzzzzzzzz

------------------------------------------------
now if I updated it, the PHP would kick out something like this
------------------------------------------------

2005 - 01 - 02

new message

2004 - 12 - 02

blabla

2004 - 11 - 02

blablabla

-------------------------------------------

does this make anymore sense?

does anyone understand what I mean exactly? I need to display the three latest records from the database I've created.

Okay you mean the last three entries into the database?

Just add

PHP Code:

ORDER BY id DESC LIMIT 0,3 


to your query. "id" being the primary key of your table.

Cheers RockNRollPig. I was able to sort it out though Thanks for trying to help anyway