Counting number of rows in a table (SQL)

[oha055]

Hi,

 

I have a problem regarding counting rows in a mysql table. Here is the code:

 

<?php
require_once('includes/connection.inc.php');
$conn = dbConnect('read');
$check = 'SELECT COUNT(*) FROM images';
$checkRes = $conn->query($check) or die(mysqli_error());
if($checkRes <= 0) { header('Location: empty_blog.php'); // redirect to another page
} else { // do something else... }
?>

 

The error I'm getting: "Notice: Object of class mysqli_result could not be converted to int in C:\xampp\htdocs\photoblog\index.php on line 6"

 

Any help is greatly appreciated!

[requinix]

You aren't using mysqli correctly. Read the manual, and pay special attention to the bits about mysqli_result.

[oha055]

Ok, thank you. I'll do that.