Count Clicks

binto

I have read what I can find here but no thread seems to answer to my problem

I want to be a able to count clicks to links in my site categories
So I have:

Traders(123)
Carpenters (456)
etc.

The categories table has a column hits INT(11)

Any assistance will be appreciated

thorpe

just update the hits field everytime someone hits the page. you know how to connect to a database? your query would be simple.

UPDATE categories SET hits = hits + 1 WHERE categorie = blah;

binto

Thank you very much
I will try and let you know

binto

Hello

I appreciate your response but the update did not work

binto

I am sorry I should have mentioned I am trying to count mouse click on category links not the number of visits to the page.

Below is my code
$res=mysql_query("SELECT id,hits,name,name{$s_lang} FROM cms_category ORDER BY name");
$res_c=mysql_num_rows($res);

//$res_h=mysql_query("UPDATE cms_category SET hits=hits+1 WHERE id={$_GET['id']}");
This doesn't work. Nothing happens

//$res_h=mysql_query("UPDATE cms_category SET hits=hits+1");
This increases the count on all categories by 1

I guess my problem is how to limit the count to each category

Thanks for helping.

toxic_brain

let us see the query
change the 3rd line to

$str	=	"UPDATE cms_category SET hits=hits+1 WHERE id={$_GET['id']}";
  echo $str;

and check.

binto

Here is the code
Thank you but the change didn't work

<CODE>
$res=mysql_query("SELECT cms_category.id as cat_id FROM (cms_category INNER JOIN cms_subcategory ON cms_category.id=cms_subcategory.parentid) INNER JOIN cms_subsubcategory ON cms_subcategory.id=cms_subsubcategory.parentid WHERE cms_subsubcategory.id=$k");
$cat[mysql_result($res,0,"cat_id")]="";

}
$res=mysql_query("SELECT id,hits,name,name{$s_lang} FROM cms_category ORDER BY name");
$res_c=mysql_num_rows($res);
//$res_h=mysql_query("UPDATE cms_category SET hits=hits+1 WHERE id={$_GET['id']}");

?>
<table border=0 width=90% align=center>
<tr valign=top>
<td class=f14>
<ul>
<?
for($i=1;$i<=ceil($res_c/2);$i++)
{
$name=mysql_fetch_array($res);

echo "<li>".(isset($cat[$name['id']]) ? "<a href='".str_replace(" ","",str_replace(" & "," and ","category/{$name['name']}"))."'>".$name["name{$s_lang}"]."</a>" : "<a href='".str_replace(" ","",str_replace(" & "," and ","category/{$name['name']}"))."' class=a2>".$name["name{$s_lang}"]."</a>")." ".$name["hits"]."<br>";
}
?>
</ul>
</td>
<td class=f14>
<ul>
<?
for($i=ceil($res_c/2);$i<$res_c;$i++)
{
$name=mysql_fetch_array($res);
echo "<li>".(isset($cat[$name['id']]) ? "<a href='".str_replace(" ","",str_replace(" & "," and ","category/{$name['name']}"))."'>".$name["name{$s_lang}"]."</a>" : "<a href='".str_replace(" ","",str_replace(" & "," and ","category/{$name['name']}"))."' class=a2>".$name["name{$s_lang}"]."</a>")." ".$name["hits"]."<br>";
}
?>
</CODE>

gufmn

It wasn't supposed to fix anything. It was intentded to just display the query to make sure your passing the correct value from $_GET['id']

toxic_brain

do one more thing,

paste and run the dispalyed query on ur database using any mysql querying apllication like mysql front end or mysql query browser and see the result..