ok,
if i understand you correctly, you're taking data from a form and want to
check that it is not already in the database, right?
then why don't you include the submitted vars in the query like this:
$sql = "SELECT First_Name, Last_Name, Address FROM $table_name
WHERE (Family_Position = 'H' or Family_Position = 'S') and "first_name =
'$form_First_Name' and last_name='$form_last_name' and
address='$form_address'";
$result = @mysql_query($sql,$connection) or die(" Couldn't execute query.");
$number_of_matches = mysql_num_rows($result);
if ($number_of_matches > 0)
{print "bla bla";
else{
//submitted info is ok and can be inserted ....
}
please correct me if i missunderstood your question
regards
At 21:52 04/08/01, you wrote:
>Here is the query part:
>
>$sql = "SELECT First_Name, Last_Name, Address FROM $table_name
>WHERE Family_Position = 'H' or Family_Position = 'S'";
>//$result = @mysql_query($sql,$connection) or die(" Couldn't execute query.");
>if(! $result = mysql_query($sql,$connection)) {
> print("ERROR ".mysql_errno().":
> ".mysql_error()."<br>\n$sql<br>\n");
> }
>
> >
> > whta does your query look like?
> >
> > At 19:40 04/08/01, you wrote:
> > >After a sign up page I want to check if someone is already entered
> > >into a database. The First Name, Last Name and Address all have
> > >to match exactly in order for it to be considered a duplicate. However
> > >this isn't doing what I want. I get the Error produced if the Address
> matches
> > >but the name doesn't. Not sure what I'm doing wrong. Thanks.
> > >Jeff Oien
> > >
> > >while ($row = mysql_fetch_array($result)) {
> > > $First_Name = $row['First_Name'];
> > > $Last_Name = $row['Last_Name'];
> > > $Address = $row['Address'];
> > >
> > > if (($M_First_Name || $F_First_Name == $First_Name) &&
> > > ($M_Last_Name || $F_Last_Name == $Last_Name)
> > > && ($Address1 == $Address)) {
> > > echo "
> > > <html><head><title>Error</title> </head>
> > > <body bgcolor=\"#FFFFFF\" text=\"#000000\" link=\"#0000ff\"
> > > vlink=\"#660099\">
> > > <h3>Error</h3>
> > >etc...
> > >
> > >--
> > >PHP General Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
