number of idems for each category

CodyNPaige

hey every one

I'm trying to pull the amount of idem I have stored in each category but I can't seem to finger out the right way to do it.

This is the code I have tried but no luck

<?php

$link_query = "SELECT count(*) FROM link " .
                "WHERE catalogid={$row['linkid']}";
        $link_result = mysql_query ($link_query);
        $link_row =mysql_fetch_row($link_result);

?>

<?php print "($link_row[0])"; ?>

Weedpacket

What does it do instead?

CodyNPaige

Weedpacket wrote:
What does it do instead?

it dose nothing. I have a list of categories and idems in all the different categories I'm trying to pull the amount of idems in each different category what im getting is

Family ()

where () is where I was trying to pull up the amount of idems in that cat

bradgrafelman

Try doing some debugging:

$link_result = mysql_query ($link_query) or die('MySQL error: ' . mysql_error() . '<hr/>Query: ' . $link_query);

The quotes are unneccesary (and actually bad coding) if you're just printing a variable itself, so remove the quotes from your print() statement.

CodyNPaige

bradgrafelman wrote:
1. Try doing some debugging:
$link_result = mysql_query ($link_query) or die('MySQL error: ' . mysql_error() . '<hr/>Query: ' . $link_query);
The quotes are unneccesary (and actually bad coding) if you're just printing a variable itself, so remove the quotes from your print() statement.

I get this error
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query: SELECT count(*) FROM link WHERE catalogid=

bradgrafelman

And where is $row['linkid'] defined? Or, where is it supposed to come from?

CodyNPaige

bradgrafelman wrote:
And where is $row['linkid'] defined? Or, where is it supposed to come from?

thats just one of the ways I have tried to get it to work I'm just not sure what is the right way to do it 😕

I've tried

<?php
$catalogId = $row['linkid'];
$sql = "SELECT COUNT(*) total FROM link WHERE catalogid = $catalogId";
$result = mysql_query ($sql);
$row = mysql_fetch_row ($result);
?>

<?php print $row['total']; ?>

and also tried but this one list the same number on each category the same number is the full amount I have stored in the db

<?php
$sortby = "catalogid";
$sql="SELECT count(linkid) AS count FROM link";
$result=mysql_query($sql);

$row = mysql_fetch_array($result);
$link = $row["count"];
?>

<?php echo "$link" ?>

bradgrafelman

As I asked before... where is this variable supposed to come from? The URL (e.g. in the query string)?