|
Posted by Norman Peelman on 07/23/07 02:19
up2trouble wrote:
>
> Its an integer set at 1 space. I changed code to:
>
> function adminApprovalNeededDir ($connect, $db_table8)
> {
> $sql = "SELECT COUNT(*) FROM $db_table8 WHERE approved = 0 ";
> $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.";
> }
>
> I'm still getting same result.
>
You'll need to post your table definition here and just one more
thing are you sure $db_table8 refers to the correct table? There is
nothing in that query that would limit your results. Can you verify
through the MYSQL shell/command line?
Norm
Navigation:
[Reply to this message]
|