Date: Fri, 9 Aug 2002 09:04:16 -0700 From: Nathan Kinkade <nkinkade@dsl-only.net> 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: <20020809090416.5a47f607.nkinkade@dsl-only.net> In-Reply-To: <001801c23fbc$879e5f60$6701a8c0@SURVIVAL> References: <001801c23fbc$879e5f60$6701a8c0@SURVIVAL>
next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 9 Aug 2002 11:50:47 -0400
"MET" <met@uberstats.com> wrote:
> 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.... ??
>
> Line 267 is equal to this PHP line:
>
> $RSM = mysql_fetch_array($resultm);
>
> =============================
> ERRORS:
> =============================
>
> Warning: Supplied argument is not a valid MySQL result resource in
> D:\Gunks\NewSite\phpAds\view.inc.php3 on line 267
<snip>
> CODE:
> =============================
>
> function view_order($keywords, $id)
> {
> global $phpAds_db, $phpAds_hostname, $phpAds_mysqluser,
> $phpAds_mysqlpassword, $REMOTE_HOST, $USER, $phpAds_tbl_banners;
<snip>
> mysql_connect($phpAds_hostname,$phpAds_mysqluser,$phpAds_mysqlpasswor
> d) or die("Unable to connect to database");
> @mysql_select_db("$phpAds_db") or die("Unable to select database
> $phpAds_db");
>
> if($USER[$id]["cbannerID"] == -1)
> {
> $sqlm = "SELECT MIN(bannerID), MAX(bannerID) FROM
> banners WHERE active='true';";
>
> $resultm = mysql_query($sqlm);
>
> $RSM = mysql_fetch_array($resultm);
This may be my own lack of knowledge on PHP, but what is the "@" symbol
before your call to mysql_select_db? I'm not familiar with that
construct in PHP, only PERL, but again, it may just be that I don't know
PHP well enough. Also, are you sure that your query ($sqlm) is
returning any results? Try checking for a result set with
mysql_num_rows before fetching the result array. I see that you are
using the mysql_num_rows function at other places in your code.
Nathan
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?20020809090416.5a47f607.nkinkade>