users create an account like so:
Code: Select all
$ti = "INSERT INTO accTable (name, nameU, profession, company, site, email, word, country)
VALUES ('$accNameSafe', '$accNameUSafe', '$accProfessionSafe', '$accCompanySafe', '$accSiteSafe', '$accEmailSafe', '$accPassSafe', '$accCountrySafe')";
mysql_query($ti, $con);Code: Select all
$sql = "SELECT `email`, `word` FROM `accTable` WHERE `email` = `$email` AND `word` = `$password`";
$result = mysql_query($sql) or die(mysql_error());
$count = mysql_num_rows($result);
if($count == 1)
{ blah blah blah
What's going on?Unknown column '*my email address*' in 'where clause'
thanks