Thank you. That worked and I'm sure will have made it work a lot
faster later on when there is a lot of data in the database.
Jeff Oien
> On Sat, 4 Aug 2001 12:40:42 -0500, Jeff Oien ([EMAIL PROTECTED])
> 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: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: php-list-
> >[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]
>
--
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]