a simple question

[riotx]

well I am very new to php/my sql and what I want to do is quite simple

I can make a script to display the first record in my database,

(very simple)

<?php

$db = mysql_connect("localhost", "username", "password");

mysql_select_db("database",$db);

$result = mysql_query("SELECT * FROM table",$db);

printf("Field 1: %s<br>\n", mysql_result($result,0,"title"));

printf("Field 2: %s<br>\n", mysql_result($result,0,"menu"));

?>

As I say I am new to this so how could I modify this script to display the LAST entry in the database?

Thanks

[AshtrayWaterloo]

Okay, you can do this a number of ways. I would recommend this way but it's just one way of doing things. This way, it prints the last row of data.

<?php

$db = mysql_connect("localhost", "username", "password");

mysql_select_db("database",$db);

$result = mysql_query("SELECT * FROM table LIMIT 1,-1",$db);

while ($row = mysql_fetch_assoc($result)) {

printf("Field 1: %s<br>\n", $row['title']));
printf("Field 2: %s<br>\n", $row['menu']));

}

mysql_free_result($result);
?>

Ash