Hi guys im pretty new at this and cant seem to get this going.... I want the
code to query the database for the number of messages posted within the last
month this is the code i have but its not working... I might even have it
all wrong, can someone point me in the right direction?
$lastmonth = date("YmdHis", mktime(date("H"), date("i"), date("s"),
date("m")-1, date("d"), date("Y")));
$countResult = db_query("SELECT count(*) AS msgCount FROM messages WHERE
uid = '". $userID ."' AND fid = '". $fid ."' AND post_date <= '". $lastmonth
."'");
$countRow = db_fetch_array($countResult);
im then using $countRow as my variable but it keeps returning a value of
zero.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
