query errors

lilRachie

ok I'm getting an error in line 9

$sql = "SELECT * FROM database.table WHERE table.email = '$email'"; //line7
$ExecuteQuery = mysql_query($sql); //line8
$row_count = mysql_num_rows($ExecuteQuery); //line9

It used to work, but I transfered to a new server and now it doesn't.

Any ideas? clues? suggestions?

TIA
lilRachie
🆒

planetsim

What is the error i can only guess that the table doesnt exist or table.email

lilRachie

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myurl/public_html/join/join.php on line 9

planetsim

Seems to be your Query from that.

$sql = "SELECT * FROM `database`.`table` WHERE `table`.`email` = '$email'"; //line7
$ExecuteQuery = mysql_query($sql)or die(mysql_error()); //line8
$row_count = mysql_num_rows($ExecuteQuery); //line9

Also im a little confused on why you are using ` on everything, its not needed within Queries

lilRachie

I use ` because it won't work without them.

What's wrong with my query? It worked on my old server.

TIA
lilRachie