[snip]
>
> $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.
Firstly, I've never come across the function db_query or db_fetch_array,
what are they? Are they 'home grown' or a readily available database
abstraction function set? (php.net function search returns no match)
Secondly I find it easier (to read) to code my SQL statements thus:
$countResult = db_query("SELECT count(*) AS msgCount FROM messages WHERE
uid='$userID' AND fid='$fid' AND post_date<='$lastmonth'");
Finally, yes, echo the SQL statement so you know that all the variables are
being set correctly.
$sql = "SELECT count(*) AS msgCount FROM messages WHERE uid='$userID' AND
fid='$fid' AND post_date<='$lastmonth'";
echo "SQL statement = $sql ";
$countResult = db_query($sql);
$countRow = db_fetch_array($countResult);
echo "Result array = ";
print_r($countRow);
HTH
Graham
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
