read last row

[Anon]

Hello.

In a database, i have a table called site_item. The table contains three feilds, "id", "title" and "text". What i need to be able to do is read the last row of the table (the one most recently added) and store the value located in the id collum in a variable. The id collum is auto incrementing (that is, the first entry for id reads 1, the second entry reads 2 and so forth) Can anyone help me?

[alrotem]

Hi,

try this:
select * from site_item
where id = (select max(ID) from site_item)
Achi.

[sepodati]

You can use mysql_insert_id() to get the number right after you do an INSERT.

$result = mysql_query("INSERT INTO ...");
$id_num = mysql_insert_id($link_id);

where $link_id is what's returned from mysql_connect();

If you're not looking for the number directly after your insert, then you can use this query:

SELECT MAX(id) FROM table;

---John Holmes...

[Anon]

thanks everyone, it works great! 🙂