can't find my error need fresh eyes

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /home/smith/public_html/addressbook/ab_functions.php on
line 87
Query failed:

function adminApprovalNeeded ($connect, $db_table4)
{
$sql = "SELECT * FROM $db_table4 WHERE 'approved' = '0'";
87 --> $result = mysql_query ($sql, $connect) or die ('Query failed:
' .mysql_error());
$approved = mysql_num_rows($result);
echo "Address Book - You have $approved entries waiting for
approval.";
}

On Fri, 20 Jul 2007 09:23:00 +0200, gagal <lynettesmith@gmail.com> wrote:

> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
> resource in /home/smith/public_html/addressbook/ab_functions.php on
> line 87
> Query failed:
>
> function adminApprovalNeeded ($connect, $db_table4)
> {
> $sql = "SELECT * FROM $db_table4 WHERE 'approved' = '0'";
> 87 --> $result = mysql_query ($sql, $connect) or die ('Query failed:
> ' .mysql_error());
> $approved = mysql_num_rows($result);
> echo "Address Book - You have $approved entries waiting for
> approval.";
> }

The error is earlier, in the connection or the assigning it to $connect
itself. $connect does not hold a valid mysql-resource.
--
Rik Wasmus

..oO(Rik)

>On Fri, 20 Jul 2007 09:23:00 +0200, gagal <lynettesmith@gmail.com> wrote:
>
>> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
>> resource in /home/smith/public_html/addressbook/ab_functions.php on
>> line 87
>> Query failed:
>>
>> function adminApprovalNeeded ($connect, $db_table4)
>> {
>> $sql = "SELECT * FROM $db_table4 WHERE 'approved' = '0'";
>> 87 --> $result = mysql_query ($sql, $connect) or die ('Query failed:
>> ' .mysql_error());
>> $approved = mysql_num_rows($result);
>> echo "Address Book - You have $approved entries waiting for
>> approval.";
>> }
>
>The error is earlier, in the connection or the assigning it to $connect
>itself. $connect does not hold a valid mysql-resource.

Additionally, if that's the real code, the query will never return
anything, because 'approved' will never be equal to '0' ...

Micha

On Fri, 20 Jul 2007 10:33:28 +0200, Michael Fesser <netizen@gmx.de> wrote:
> .oO(Rik)
>> On Fri, 20 Jul 2007 09:23:00 +0200, gagal <lynettesmith@gmail.com>
>> wrote:
>>> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
>>> resource in /home/smith/public_html/addressbook/ab_functions.php on
>>> line 87
>>> $sql = "SELECT * FROM $db_table4 WHERE 'approved' = '0'";
>>> 87 --> $result = mysql_query ($sql, $connect) or die ('Query failed:
>>
>> The error is earlier, in the connection or the assigning it to $connect
>> itself. $connect does not hold a valid mysql-resource.
>
> Additionally, if that's the real code, the query will never return
> anything, because 'approved' will never be equal to '0' ...

He, indeed, sharp eye. Backticks, single quotes, aargh :-)
--
Rik Wasmus

On Jul 20, 4:33 am, Michael Fesser <neti...@gmx.de> wrote:
> .oO(Rik)
>
>
>
> >On Fri, 20 Jul 2007 09:23:00 +0200, gagal <lynettesm...@gmail.com> wrote:
>
> >> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
> >> resource in /home/smith/public_html/addressbook/ab_functions.php on
> >> line 87
> >> Query failed:
>
> >> function adminApprovalNeeded ($connect, $db_table4)
> >> {
> >> $sql = "SELECT * FROM $db_table4 WHERE 'approved' = '0'";
> >> 87 --> $result = mysql_query ($sql, $connect) or die ('Query failed:
> >> ' .mysql_error());
> >> $approved = mysql_num_rows($result);
> >> echo "Address Book - You have $approved entries waiting for
> >> approval.";
> >> }
>
> >The error is earlier, in the connection or the assigning it to $connect
> >itself. $connect does not hold a valid mysql-resource.
>
> Additionally, if that's the real code, the query will never return
> anything, because 'approved' will never be equal to '0' ...
>
> Micha

Yes, it is real code. After you said it wouldn't work, I went back
and tried again. It works this time (no 0 return). I still don't
understand why I am getting the error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /home/smith/public_html/addressbook/ab_functions.php on
line 95
Query failed:

I am using the same code in another functions page and it works. This
one works:

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 "Directory - You have $approved entries waiting for approval.";
}

This one doesn't work:

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

They are on seperate pages so they do not cause conflict with each
other. Please help!

Thanks. I finally found my very stupid error and fixed it. I still
have 1 question. Why are my posts delayed by several hours? It used
to be only a few minutes.

On Fri, 20 Jul 2007 17:01:17 +0200, gagal <lynettesmith@gmail.com> wrote:
> Thanks. I finally found my very stupid error and fixed it. I still
> have 1 question. Why are my posts delayed by several hours? It used
> to be only a few minutes.

Don't use Google Groups. It was crap to begin with, and even shittier the
last several days. Use a real NNTP server & client, and the speed & user
comfort will be amazing.

Then again, delays are part of usenet.
--
Rik Wasmus