Returning Primary Key

Hello,

My mysql table is setup as the following:

billingid (Primary Key, auto_increment)
userid
billingdate
invoice

I have a script that is inserting data into a mysql database table.
mysql_query("INSERT INTO billing SET userid='$userid', billingdate='$billingdate', invoice='$invoice'");

What I want to know is if there is a way to return the billingid value for the row that is inserted without querying the database for the record?

For Example:
mysql_query("INSERT INTO billing SET userid='$userid', billingdate='$billingdate', invoice='$invoice' RETURN billingid");


Thanks
jlimited

as long as you have `billingid` as an AUTO INCREMENT field, use mysql_insert_id() (http://us2.php.net/manual/en/function.mysql-insert-id.php)