Problems with views Help !!

[kiril_cvetkov]

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

[Marco van Herwaarden]

PHP Code:

$db->query_read("UPDATE ".TABLE_PREFIX. "tabela_cat SET views=views+1"); 


query_read() should only be used to read from the database, not to write to it.