Date: Fri, 9 Aug 2002 17:56:18 +0200 From: Roman Neuhauser <neuhauser@bellavista.cz> To: MET <met@uberstats.com> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Off the Main Topic || Supplied argument is not a valid MySQL result resource Message-ID: <20020809155618.GG389@freepuppy.bellavista.cz> In-Reply-To: <001801c23fbc$879e5f60$6701a8c0@SURVIVAL> References: <001801c23fbc$879e5f60$6701a8c0@SURVIVAL>
next in thread | previous in thread | raw e-mail | index | archive | help
> From: "MET" <met@uberstats.com>
> To: <freebsd-questions@FreeBSD.ORG>
> Subject: Off the Main Topic || Supplied argument is not a valid MySQL result resource
> Date: Fri, 9 Aug 2002 11:50:47 -0400
>
> I realize that this is off topic, but I'm sending it to more specific
> PHP lists as well but none of them have such helpful people on them.
>
> I'm getting some massive errors on some pretty simple code. Included
> are the errors as well as the PHP function that is giving me issues.
> Any help would be greatly appreciated. And the weirdest thing, is that
> the code used to work.... ??
> Warning: Supplied argument is not a valid MySQL result resource in
> D:\Gunks\NewSite\phpAds\view.inc.php3 on line 267
> $sqlm = "SELECT MIN(bannerID), MAX(bannerID) FROM
> banners WHERE active='true';";
>
> $resultm = mysql_query($sqlm);
>
> $RSM = mysql_fetch_array($resultm);
So, this is all that was really needed along with saying which line
in your script is the "line 267".
Anyway, just a wild guess: remove the semicolon from the SQL query.
And a solution: put a "echo mysql_error($resultm);" just after the
mysql_query($sqlm) line.
--
FreeBSD 4.6-STABLE
5:52PM up 5:47, 8 users, load averages: 0.00, 0.00, 0.00
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020809155618.GG389>