RE: [php_mysql] How can avoid duplicate entry

2008-01-26 Thread Leelakh Ran
Dear intekhab, Thanks for these valuable information. With thanks, Leelakh Ran. _ From: php_mysql@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of intekhab rizvi Sent: Monday, January 21, 2008 6:36 PM To: php_mysql@yahoogroups.com Subject: Re: [php_mysql] How can avoid

Re: [php_mysql] How can avoid duplicate entry

2008-01-21 Thread intekhab rizvi
Hi Leelakh, Here is your answer. For no 1 '0') { echo "Sorry Already Have Infomation"; } else { //here type your database insert query } ?> For no 2 //pls insert this script on your form page after copying this make new fileld with name what ever you want. //pls insert this scrip

[php_mysql] How can avoid duplicate entry

2008-01-18 Thread Leelakh Ran
Dear members, I have one form to accept name, address and city of the user. Sometimes some users sending same data several times. So I want to solve this peoblem by following two ways. 1) comparing input data with database table. It is the fields tname, taddress and tcity from table1 on db1