SQL error with PHP

[Anon]

quote:

Warning: 0 is not a MySQL result index in backend.php on line 77

code:
$query = mysql_query(\"select id from data where email = \'$email\'\"); $result = mysql_num_rows($query); if ($result > 1) { mysql_close(); return $this->error[13]; }

(line 77 is $result= ......)

[Anon]

Have you already connected to the Database? If not, you have to do this:

$db = mysql_connect($mysqlhost, $mysqluser, $mysqlpass);
mysql_select_db($mysqldb, $db);
and then for your query you would go:

$query = mysql_query(\"select id from data where email = \'$email\'\", $db);

Hope this helps

[Anon]

yes I have

[Anon]

Why oh why do people never ever use any error checking??

Use IF statements to check if the database connection worked, and print mysql_error() if it didn't.