members information on main page. NEED HELP!

If anyone knows a php script that can diaplay the number of registered members, the newest registered member and his/her profile linked to that , will be on my main page not the forum pages. Like the main page on http://www.FlashKit.com

If any one can help me, it would be a blessing!

PS: I tried to make my own from the top 10 post script idea but it bombed out

Mike

Wayne--
: is the directory delimiter in php.ini for *nix. ; is used for Win32.

Don't require your config.php accross the web- just put the full path to it (/full/path/to/config.php)

Every thing is good on my end. I am working on some other information I want extracted from data. I want to know also how to get the latest username created, I think it's done but getting the latest time/date but I seem not able to get the latest one it's always the first one ever made.

I'll figuar it out one day, but If anyone got that down packed let me know

mike

Hmph... It still seems to not work.. I changed everything, but still get an error.

http://www.soapedup.f2s.com/testing.php

Ed,

With that in mind would this code:

  	$pmcounta = $DB_site->query_first("SELECT COUNT(msgid) AS msgid FROM privatercvd WHERE toid=$bbuserid");
  	$pmcount = $pmcounta[msgid];
  	$newpmcounta = $DB_site->query_first("SELECT COUNT(msgid) AS msgid FROM privatercvd WHERE toid=$bbuserid AND UNIX_TIMESTAMP(datetime)>$bblastvisit");

be better off like this:

  	$pmcounta = $DB_site->query_first("SELECT COUNT(*) AS msgid FROM privatercvd WHERE toid=$bbuserid");
  	$pmcount = $pmcounta[msgid];
  	$newpmcounta = $DB_site->query_first("SELECT COUNT(*) AS msgid FROM privatercvd WHERE toid=$bbuserid AND UNIX_TIMESTAMP(datetime)>$bblastvisit");

James--
Yes. vB2 has all those kinds of optimizations and more.