[SOLVED] retrieving auto_increment info

[c1t1z3n]

i have setup a database table with the fields id (int auto_increment)

and data (varchar) and am using the following to add records to the database:

 

      $q = "INSERT INTO database_table ('data') VALUES ('$data')";
      $result = mysql_query($q);

 

how do i determine which value the auto_increment column (id) was given when the database was updated?

[Maq]

You can use mysql_insert_id.  All the information you need is in the manual link.