Hi i have one problem with coding in vbulletin
I have one row and X queries.
I am making views hit counter to my coded categories
here is the code :
PHP Code:
$db->query_read("UPDATE ".TABLE_PREFIX. "tabela_cat SET views=views+1");
$views= $db->query("SELECT views FROM ". TABLE_PREFIX . "tabela_cat");
while ($prom = $db->fetch_array($views))
{
$views = $prom['views'];
}
Now the problem is that on all my queries it show me equal views
please help me
--------------- Added 03 Apr 2008 at 16:05 ---------------
never mind

i try with this :
$db->shutdown_query("
UPDATE " . TABLE_PREFIX . "tabela_cat SET views = views + 1 WHERE catid =".$row['catid']);
and it's working