Posted by Norman Peelman on 07/22/07 11:55

up2trouble wrote:
> 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.";
> }
>

Is the field 'approved' a TEXT field or a numeric field (INT for
example)?

If its a numeric field then:

SELECT * FROM $db_table8 WHERE approved = 0

should work. You don't use quotes around numeric fields (INT, FLOAT,
etc.) and always use them around TEXT fields (even if the data is numbers).

Norm

[Back to original message]