error code need help

i use this code in member.php

$ppoopp=$DB_site->query_first("SELECT count(*) AS counter FROM attachment WHERE userid='$bbuserinfo[userid]'");
$xx=$ppoopp['counter'];

i want to count all attach file download times for each member

for example:

a user download 55times than in profile show up 55 times he download

but above the code it always show up the same number

i think it maybe some where wrong hope some one tell me

what's wrong with that code?? thankz~~

[nuno]

try this
$ppoopp=$DB_site->query_first("SELECT count(*) AS count FROM attachment WHERE userid='$bbuserinfo[userid]'");
$xx=$ppoopp['counter'];

[FWC]

Originally posted by squawell
i use this code in member.php

$ppoopp=$DB_site->query_first("SELECT count(*) AS counter FROM attachment WHERE userid='$bbuserinfo[userid]'");
$xx=$ppoopp['counter'];

i want to count all attach file download times for each member

for example:

a user download 55times than in profile show up 55 times he download

but above the code it always show up the same number

i think it maybe some where wrong hope some one tell me

what's wrong with that code?? thankz~~

Try:

$ppoopp=$DB_site->query_first("SELECT sum(counter) AS counter FROM attachment WHERE userid='$bbuserinfo[userid]'");
$xx=$ppoopp['counter'];

[squawell]

thankz both of u --FWC and nuno~~~

but it still cann't work~~

the problem still here~~~

[squawell]

have any idea with this??