Select last row of the table?

[Anon]

Dear all,

Using php and mysql, we insert a set of the data into the table except the column "id", since the id is automatically increased by one. I want to take the id immediately for set of data just inserted. Please reply me how to do. thanks

Sincerely yours,
Simon

[Anon]

try this

SELECT MAX(LAST_INSERT_ID(id)) FROM table_name

[[deleted]]

That doesn't make any sense.

Instead, fetch the mysql_insert_id() immediately after executing an insert query.

if ($result = mysql_query("INSERT bla"))
{
echo "Last insert ID:".mysql_insert_id();
}
else
{
echo "Query failed";
};

[Anon]

SELECT * FROM table ORDER BY field_id DESC LIMIT 0,1

[[deleted]]

Close but not correct.
This will fetch the last inserted record, not the last record inserted by you

The difference:
When you open a connection and insert a record, the ID of that record is stored
for your database connection and can be fetched by mysql_insert_id().
This means that no matter how many records other people insert after your insert, you will allways see the id of the last record inserted by on your database connection.

The method that you just posted fetches the last record inserted into the table.
that means that if somebody else inserts a record while you are running this query, you will get that record, insertead of the record you inserted.

[kparker]

Hey Vincent, this subject would make another good entry into your Yet Another PHP FAQ page (unless we've already done it!)

[[deleted]]

Indeed it would.

Care to do it? :-)

[Anon]

Example:

in case of your database name is db1,table name is tb1.

<?
//connect to mysql server.
$link_id=mysql_connect("localhost","root","");
//select database db1
mysql_select_db("db1",$link_id);
//insert a record into tb1
$sql="insert into tb1 values('','field1_value','field2_value'...);
mysql_query($sql);
//get the last id
$sql="select max(id) as max_id from tb1";
$result=mysql_query($sql);
list($max_id)=mysql_fetch_array($result);
//display the max_id
echo $max_id;
//close mysql server's connect
mysql_close($link_id);
?>

That's all.

Yukee Lau

22-Jul-2001