Posted by up2trouble on 07/22/07 04:08

I posted before about a different problem and one of you commented
that another aspect of my code would not work anyway. Well, I thought
I had fixed it. Boy was I wrong.

I have a field in my table where once something is submitted it
doesn't post until approved. 0 for not approved, 1 for approved. I am
trying to count the number of non-approved items in my table to report
it on the admin page. I get:

Directory - You have 1 entries waiting for approval.
Address Book - You have 1 entries waiting for approval.

I know I have a lot more than 1 waiting for approval.

function adminApprovalNeeded ($connect, $db_table8)
{
$sql = "SELECT * FROM $db_table8 WHERE approved != '1'";
$result = mysql_query ($sql, $connect) or die ('Query failed:
' .mysql_error());
$approved = mysql_num_rows($result);
echo "<STRONG>Directory</STRONG> - You have $approved entries waiting
for approval.";
}

[Back to original message]