[SOLVED] find out the value of an auto_increment field?

[wmguk]

Hey guys, Im running a double script, basically 1st code inserts somethings in to one table, and 2nd code inserts other vars in to the 2nd table, how can i find out what the autoincrement result was, so i can use it as a refnum in my second table?

 

the info is

 

table one.

 

refnum (Auto) | name | colour | style | clear | special | pic | info

 

table two

 

refnum (Auto) | originalprod (this needs to be tbl1-refnum) | Size | Cost

 

hope this makes sense....

 

so, how can i find out the value that mysql assigned the insert?

[wmguk]

$refnum = mysql_insert_id ();