count the entire privite messages

[mcncyo]

I would like to display on my home page the total number of private messages on the board at this time.

I just need the mysql querry that doees this and put in into a varaibe like privitemessagetotal

[the_sisko]

PHP Code:

$numpms = $DB_site->query("SELECT * FROM privatemessage");
$numpm = mysql_num_rows($numpms); 


$numpm gives you the total PM's in database!

Also look at the RELEASE FORUM and look for my CP PM Stats Hack