Returning 1

NZ_Kiwis

#check email not in use
$results = $mysqli->query("SELECT COUNT(*) FROM `users` WHERE EmailAddress = '$Email'") or die(mysqli_error($mysqli)); 	
$numrows = mysqli_num_rows($results);

I have this code, when i run it in phpMyAdmin i get o, when i run it on my webpage I get 1 but my table has 0 rows.

What could be wrong?

cluelessPHP

Wouldn't it be better to use ?

SELECT SQL_CALC_FOUND_ROWS

$Email is doing what? I'm not sure

Bonesnap

I don't believe you can mix object-oriented MySQLi and procedural MySQLi.

For queries that include 'SELECT', $mysqli->query() returns a mysqli_result object, which is $results. You are then passing that result object to mysqli_num_rows. What you should really be doing is:

#check email not in use
$results = $mysqli->query("SELECT COUNT(*) FROM `users` WHERE EmailAddress = '$Email'") or die(mysqli_error($mysqli));     

$numrows = $results->num_rows; //This line is changed slightly.

Check the manual for more info.

Weedpacket

Because your query returns one row, containing one column, containing the result of the COUNT(*) operation.