Just let me know if u have a primary key.
If it's there then u r duplicating the value already present in the primary key field.
Thanks, Pradeep
Joseph Harris wrote:
I have one table and form and php insert working well and thought I had applied its lessons. But I am getting this below. I have tried a lot of combinations but this seems the sticking point. Advice welcome---
SQL-query : INSERT INTO spw_addresses( spw_addresses_id, spw_addresses_company, spw_addresses_building, spw_addresses_number, spw_addresses_street, spw_addresses_street2, spw_addresses_town, spw_addresses_statecp, spw_addresses_country, spw_addresses_zipcode, spw_addresses_phone, spw_addresses_fax, spw_addresses_email1, spw_addresses_email2, spw_addresses_email3, spw_addresses_website1, spw_addresses_website2 ) VALUES (
'', '$_POST[company_name]', '$_POST[building]', '$_POST[number]', '$_POST[street1]', '$_POST[street2]', '$_POST[town]', '$_POST[state] ', '$_POST[country]', '$_POST[zip]', '$_POST[phone]', '$_POST[fax]', '$_POST[email1]', '$_POST[email2]', '$_POST[email3]', '$_POST[web1]', '$_POST[web2]' )
MySQL said:
#1062 - Duplicata du champ '0' pour la clef 1
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016
Please include the email address which you have been contacted with.
____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016
Please include the email address which you have been contacted with.
