[help]i need a little help

this is the problem code:

PHP Code:

$fileviews=$DB_site->query_first("SELECT count(*) AS profileviews FROM user ORDER BY profileviews DESC LIMIT 1");
$proviews=$fileviews['profileviews']; 

but the $proviews=totalmembers what's wrong??


hope anybody help me finish it~~plz~~~

[amykhar]

all this query did was count the total number of users and store it in a variable called profileviews. What are you trying to calculate?

Amy

[squawell]

i want to calculate the top profileviews of forum member!!

just like :

The Top Profileview:username(numbertimes)!!

any idea??

[amykhar]

assuming that you have been counting the profile views, it's simple.

Select profileviews as profileviews from user order by profileviews DESC;

That will order them from highest to lowest. You just grab as many as you need then. If you only need the top 5 or so, you can add a LIMIT 5 at the end.

If you haven't been incrementing that field when somebody looks at a user's profile though, that query won't do anything for you.

Amy

[squawell]

thankz amy~~~

now it's work!!

another question

if i want the top 5 show up with pop up window how should i do?

any idea?