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>