Get mysql data from insert

[direwolf]

I am inserting some data into a mysql table which has an auto_increment id column.

Is there a way to get the number from that column so I can use it in the same script?

i.e. the INSERT function is run and then I can assign the auto_increment number to a variable?

// Insert data
  $sql = mysql_query("INSERT INTO table SET name='$name'");
  
  // do something to get the auto_increment number that was created in table for the INSERT
  
  $name_id =  // <- assign it to a variable 

[mediallusion]

you want to use the function mysql_insert_id($sql)) to retrieve the last id of the insert query

[phpster]

$name_id = mysql_inset_id($result);

[direwolf]

cool thanks

[direwolf]

hmmmm

When I try it I get

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /home/.... 

// Insert data
   $sql = mysql_query("INSERT INTO table SET name='$name'");
   
   $name_id = mysql_insert_id($sql); 
 
   echo $name_id; 

[Bobbi]

I think I ran into issues once with both of them ... so I ended up doing it with a query like this:

$lastid = mysql_result(mysql_query("SELECT id FROM table ORDER BY id DESC LIMIT 0,1"),0,"id"); 

Not the cleanest solution, but at least it works

Bobbi

[stereofrog]

hmmmm

When I try it I get

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /home/.... 

// Insert data
   $sql = mysql_query("INSERT INTO table SET name='$name'");
   
   $name_id = mysql_insert_id($sql); 
 
   echo $name_id; 

mysql_insert_id() requires connection id or just nothing as param, not the query result.

[direwolf]

ahhh yes!

Thanks for that. Removed the $sql out and now it works a treat.