* Thus wrote Dan Anderson ([EMAIL PROTECTED]):
>
> > $chk = "Select id, fname from contact_info where email =" . $email;
>
> You need to quote the email. So perhaps the following would be more
> appropriate:
>
> $chk = "SELECT id, fname FROM contact_info WHERE email = \"{$email}\"";
>
> > ('$fname','$lname','$tel','$address','$city','$state','$zipcode','$country',
> > '$email')";
>
> I believe there is some problems using 's and not "s. Try using "s
> above.
Using ' is prefered IIRC, and also escaping all the data before sending
it to the database:
$fname = mysql_real_escape_string($fname);
Curt
--
List Stats: http://zirzow.dyndns.org/html/mlists/php_general/
"I used to think I was indecisive, but now I'm not so sure."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php