Posted by Rik on 07/20/07 07:25

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 =3D "SELECT * FROM $db_table4 WHERE 'approved' =3D '0'";
> 87 --> $result =3D mysql_query ($sql, $connect) or die ('Query failed:=

> ' .mysql_error());
> $approved =3D 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

[Back to original message]