Re: [PHP] MySQL error checking/matching

2002-02-17 Thread Matt
- Original Message - From: "Navid Yar" <[EMAIL PROTECTED]> > $query = "select email from customers" // Check for duplicate > entry > . "where email = $email"; > $query = stripslashes($query); > $result = mysql_query($query); > > $num_results = mysql_num_rows($result); // Get the number of

[PHP] MySQL error checking/matching

2002-02-16 Thread Navid Yar
Hello everyone, I have a problem. I have a test database (used to learn MySQL) with a table called customers and a field called email. The email field is set to be unique, so I know that by using: $query = "select email from customers where email = $email"; I will get one cell with the e-mail add