mysql更新id连带更新其引用,mysql_insert_id与更新

After executing the query below I use the PHP function mysql_insert_id() and it always gives me 0.

UPDATE

tbl_training_types

SET

fld_serial = $serial_no,

fld_name = $training_name,

fld_description = $training_description

WHERE

fld_id = $id

解决方案

When you update a note in database you already have something using what you can identify it. In your example you already have $id which should be containing the value of data you have recently updated. If you don't have id and you try to update with name or something different after update you can simply retrieve updated data with simple query:

select * from table_name where your condition

Note: mysql_* functions are deprecated and won't be supported in future versions. You should be using either mysqli_* or PDO.