this is the problem code:

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


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

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

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

just like :

The Top Profileview:username(numbertimes)!!

any idea?? :confused:

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

thankz amy~~~:D

now it's work!!

another question

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

any idea?