RE: [PHP] Retrieve value of newly inserted row.

> -----Message d'origine----- > De : Dan Shirah [mailto:mrsquash2@gmail.com] > Envoyé : mercredi 14 février 2007 19:20 > À : php-general > Objet : [PHP] Retrieve value of newly inserted row. > > Hello, > > I have a page the contains two insert statements. > > > $insert1 = "INSERT INTO table1 ( > debit_card, > card_type, > card_number, > exp_date, > payment_amount, > cvv_number, > first_name, > middle_name, > last_name, > address_1, > address_2, > city, > zip_code, > zip_4, > phone_number, > fax_number, > email_address, > receipt, > comments, > date_request_received, > employee_received_call, > research_phase_date, > research_phase_user, > submit_phase_date, > submit_phase_user, > status_code, > state_code) > VALUES ( > '$debit_card', > '$card_type', > '$card_number', > '$exp_date', > '$amount', > '$cvv', > '$cc_first', > '$cc_middle', > '$cc_last', > '$cc_address_1', > '$cc_address_2', > '$cc_city', > '$cc_zip', > '$cc_zip_4', > '$cc_phone_number', > '$cc_fax_number', > '$cc_email_address', > '$receipt', > '$cc_comments', > '$create_date', > '$create_user', > '$research_date', > '$research_user', > '$submit_date', > '$submit_user', > '$status_code', > '$cc_state')"; > mssql_query($insert1) or die ("Query failed: <br > />".mssql_get_last_message()); > > > $insert2 = "INSERT INTO table2 ( > credit_card_id, > case_number, > comments) > VALUES ( > 'card_id', > '$case', > '$comments')"; > mssql_query($insert2) or die ("Query failed: <br > />".mssql_get_last_message()); > > echo "Insert complete"; > > > > > > On my second insert statement, please note "credit_card_id". > This is an > auto_increment column in table1. What I need to do is pull > the value of "credit_card_id" from the newly inserted row > from insert1 and put that value in a variable to assign it to > "credit_card_id" in insert2. > > > > I hope that wasn't too confusing. http://cz2.php.net/manual/en/function.mysql-insert-id.php >