Posted by Rik on 07/20/07 08:56

On Fri, 20 Jul 2007 10:33:28 +0200, Michael Fesser <netizen@gmx.de> wrot=
e:
> .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 =3D "SELECT * FROM $db_table4 WHERE 'approved' =3D '0'";
>>> 87 --> $result =3D mysql_query ($sql, $connect) or die ('Query faile=
d:
>>
>> The error is earlier, in the connection or the assigning it to $conne=
ct
>> 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

[Back to original message]