php3-list | 199901

[PHP3] Boggle From: Matthew Joseff (mjoseff <email protected>)
Date: 01/23/99

This is still returning an error:

Trying to query a MySQL table for three out of four fields; if the first
name, last name, and email match, I don't want the user to be able to
enter the same data twice.

$there="SELECT * from $userstable where firstname=('$firstname') and
mname_lname=('$mname_lname') and email=('$email')";
$result=MYSQL_NUM_ROWS($there);
        IF ($result>0){
PRINT "We found $firstname $mname_lname, already in the database. Please
send email to <a href=email:webmaster <email protected>?subject=Update> the
webmaster </a> if the information found needs to be changed.";
MYSQL_CLOSE(); 

-- 
Quitters never win, winners never quit, but those who never win AND  never
quit are idiots.

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>