> -----Message d'origine----- > De : Tim [mailto:user@xxxxxxxxxxxxx] > Envoyé : mercredi 14 février 2007 19:28 > À : 'Dan Shirah'; 'php-general' > Objet : RE: Retrieve value of newly inserted row. > > > > > -----Message d'origine----- > > De : Dan Shirah [mailto:mrsquash2@xxxxxxxxx] Envoyé : mercredi 14 > > février 2007 19:20 À : php-general Objet : 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 Sorry my eyes played some tricks on me ragarding mysql/mssql refer to Robert's post on looking up "last insert id". Regards, Tim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
