>I wanna be able to do some stuff, which involves getting data from my phpBB >board. > >Member Count: (this section should autoupdate)
select count(*) from some_table_whose_name_I_do_not_know_but_you_can_look_up_in_phpMyAdmin >Number Of Forums: (this section should autoupdate) select count(*) from some_table_whose_name_I_do_not_know_but_you_can_look_up_in_phpMyAdmin >Highest Post Count: (this section shouldauto update((member) with (post >count) posts)) select member.name, count(*) as score from members, posts where posts.member_id = members.member_id group by posts.member_id, member_name order by score desc limit 1 >Most Replied to topic: (this section should auto update((topic) with (number >of replys) replys)) This one I'd have to actually look at the phpBB schema to see how they did their threading... You'd have to pay me for this answer. Sorry. I'm willing to bet that if you do the first three for yourself, you can do this last one with a minimal amount of effort. Honestly, though, you really sound like that kid in school who walked in without even trying to do his homework and said it was "too hard". -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
