Mysql id field

[Anon]

i have a mysql table with this structure:
Field | Type ....| Extra |

| id | int(10) unsigned |auto_increment |
| words | text | ....

i have a script that puts data in the database that looks something like this:
mysql_query("Insert into table (words) values ('$words')");

so my problem is that i don't know how can i pull id field after the data has been entered into database.
To make it more clear, I need to know what is the id field number of the data i just entered because i need to use it to put it in another table.

Please let me know what is the best way to do this.

[Anon]

use the mysql last_insert_id() function. Simply perform your fist query, and have your second query look something like this:
$query="INSERT INTO table VALUES(last_insert_id(), '$values')";

[Anon]

thanks didn't know that this function exist
will use mysql_insert_id();
thanks again!