With mysql_insert_id() I know it is supposed to retreive the auto-increment value inserted. Am I going wrong somewhere in my code?
What I need to do is after inserting a record into the database I need to retrieve the value of the last inserted id and store it in a variable so I can use it in subsequent insert statements.