Paging issue

[bob_the _builder]

The following works fine as a query directly in mysql..

 

SELECT COUNT(pid) as Num FROM products WHERE productgroup = 'Some Group'

 

As a whole

 

$query = "SELECT COUNT(pid) as Num FROM products WHERE productgroup = 'Some Group'";

 

$total_pages = mysql_fetch_array(mysql_query($query));

$total_pages = $total_pages[num];

 

It appears that $total_pages is empty, records display but the paging doesnt appear, as it beleaves there are no results..

 

I guess there is an issue with $total_pages = $total_pages[num]; ?

 

Maybe because the productgroup field is varchar, but I thought that COUNT(pid) would correct it?

[spiderwell]

how about using the mysql_num_rows() function?

 

$query = "SELECT pid FROM products WHERE productgroup = 'Some Group'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);

 

I havent checked this snippet for typos so it might not run from cut n paste

[bob_the _builder]

mysql_num_rows appear to work.. I never considered using it as I assumed $total_pages = $total_pages[num]; had a purpose and was needed to make the paging work..

 

Thanks

[spiderwell]

you can do it that way if you wanted, but that is often the case in programming that theres more than one way to approach it.

[cyberRobot]

Shouldn't that be "Num" with an upper-case "N"?

 

$total_pages[Num]

 

 

For future reference, turning on all errors and warnings provides clues as to what's wrong:

 

error_reporting(-1);
ini_set('display_errors', 1);

 

 

Also note that the "Num" part should be in quotes:

 

$total_pages['Num']

[bob_the _builder]

Here is what it shoud have been:

 

$total_pages = $total_pages['Num'];

 

correct upper case as cyberRobot said and also quote it as the field is varchar..

 

 

Thanks..