gettin an auto increment value in mysql right away

[keak]

Hi there,
I have a php code that inputs a row into an auto-incremented sql table. Is there a quck way to get the id assed to this row that I am inserting into?

I have something like:

  $sql = "INSERT INTO move_status SET status='new', date='$date', date_raw='$date_raw'";
  if (@mysql_query($sql)) {
    view_moving_leads();
  }
  else {
    echo ( mysql_error() );
  }

 

[spookie]

use mysql_insert_id()

http://www.php.net/manual/en/function.mysql-insert-id.php

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[Vragabond]

I do believe mysql_insert_id() can help you.

 

[keak]

Thanks, that was exactly the function i was looking for