RE: [PHP] Matching Question

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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net