Re: Matching Question

On Sat, 4 Aug 2001 12:40:42 -0500, Jeff Oien (jeff@webdesigns1.com) 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 you're going about this the wrong way. try it like this: $result=mysql_query("select * from table where first='$first' and last='$last' and address='$address'"); if(mysql_num_rows($result)){ // error code } you want to keep the result sets that mysql gives back as small as possible because they take up tons of resources. >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