John W. Holmes [EMAIL PROTECTED] wrote on 06/04/2003 05:24:22
PM:
Thanks to everyone for the suggestions. Got it fixed. Just added a
couple
lines of code -
$sql1 = select * from endusers where name like '$name';
$result1 = mysql_query($sql1);
$count1 =
Hello!!
Are talking about the same Post Question???
On another words, what is being duplicated??
If not, you can use auto_increment.
Dan
On Wednesday, June 4, 2003, at 03:13 PM, [EMAIL PROTECTED] wrote:
I need to modify some company web pages that include a form for asking
the
company
Chip,
Given that you have duplicate entries, then one field, or a combination of
several fields, will probably be unique.
Before adding a record execute a SELECT, using the values from the form
against that combination. If the number of records returned is greater than
0, then execute an
Dan Brunner [EMAIL PROTECTED] wrote on 06/04/2003 01:24:13 PM:
Hello!!
Are talking about the same Post Question???
On another words, what is being duplicated??
If not, you can use auto_increment.
Dan
This pertains to every time a person visits the page and fills in the form
- today,
I need to modify some company web pages that include a form for asking the
company departments questions, such as service dept, etc. As the forms are
currently built there is some field validation but no cookies. This info
is saved in a mysql database, problem is, there are duplicate entries,
Chip,
What's the database being used for then, if not to store and track
questions and replies? If only as a repository of addresses that 's rather
useless.
Unless you want to track the frequency of user's questions, then you could
update a counter field for their email address.
If you've
Thanks to everyone for the suggestions. Got it fixed. Just added a couple
lines of code -
$sql1 = select * from endusers where name like '$name';
$result1 = mysql_query($sql1);
$count1 = mysql_num_rows($result1);
if ($count1 == 0 )
$sql = insert into endusers..blah
Thanks to everyone for the suggestions. Got it fixed. Just added a
couple
lines of code -
$sql1 = select * from endusers where name like '$name';
$result1 = mysql_query($sql1);
$count1 = mysql_num_rows($result1);
if ($count1 == 0 )
$sql = insert into