Row counting trouble

[magicmoose]

Hi, I'm using LIMIT in my SQL query to create a paging effect for a gallery.  I need to count the total number of rows in the table, but I'm having a problem.  Instead of giving the number of rows, it simply returns the word "Array".

Any nudges in the right direction would be appreciated.

Here's the relevant part of the code, thanks.

 

$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM $gallery ORDER BY id ASC LIMIT $offset, $rowsperpage";
    $count = mysql_query("SELECT FOUND_ROWS()");
   $rows = mysql_fetch_row($count);
echo $rows;

[sasa]

look mysql_num_rows() function

[MrXander]

Instead, use:

 

$rows = mysql_num_rows($count);

[magicmoose]

It's returning 1 every time now ???

[JayBachatero]

You need to perform the query w/o the limit first.

 

$request = mysq_query("SELECT COUNT(*) FROM $gallery");
list ($totalRows) = mysql_fetch_row($request);
mysql_free_result($request);

 

I would recommend saving the value in a session that way you wont have to query the database each time.