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]
