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
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 269
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 287
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 289
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 295
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 297 less than one inside
of nothing found.
Warning: Undefined index: format in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 327
Warning: Undefined index: bannerID in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: bannerID in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: width in D:\Gunks\NewSite\phpAds\view.inc.php3
on line 333
Warning: Undefined index: height in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: alt in D:\Gunks\NewSite\phpAds\view.inc.php3
on line 333
=============================
CODE:
=============================
function view_order($keywords, $id)
{
global $phpAds_db, $phpAds_hostname, $phpAds_mysqluser,
$phpAds_mysqlpassword, $REMOTE_HOST, $USER, $phpAds_tbl_banners;
if(!isset($USER[$id]["cbannerID"])) $USER[$id]["cbannerID"] =
-1;
#############################################################
$text = explode("/", $keywords);
$keywords = "";
$x = 0;
foreach($text as $line)
{
if( $x == 0 )
{
$keywords = "(keyword LIKE '%" . $line . "%'";
}
else
{
$keywords = $keywords . " OR keyword LIKE '%" .
$line . "%'";
}
$x++;
}
$keywords .= ")";
#############################################################
mysql_connect($phpAds_hostname,$phpAds_mysqluser,$phpAds_mysqlpassword)
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);
if( mysql_num_rows($resultm) < 1 )
{
$num1 = rand(1, 100);
}
Else
{
$num1 = rand($RSM[0], $RSM[1]);
}
$sql = "SELECT
bannerID,banner,format,width,height,alt,url FROM $phpAds_tbl_banners
WHERE active = 'true' AND $keywords AND bannerID >= $num1 ORDER BY
bannerID LIMIT 0,1;";
}
else
{
$sql = "SELECT
bannerID,banner,format,width,height,alt,url FROM $phpAds_tbl_banners
WHERE active = 'true' AND $keywords AND bannerID > " .
$USER[$id]["cbannerID"] . " ORDER BY bannerID LIMIT 0,1;";
}
$result = mysql_query($sql);
$RS = mysql_fetch_array($result);
if( mysql_num_rows($result) < 1 )
{
$sql2 = "SELECT
bannerID,banner,format,width,height,alt,url FROM $phpAds_tbl_banners
WHERE active = 'true' AND $keywords ORDER BY bannerID LIMIT 0,1;";
$result2 = mysql_query($sql2);
$RS2 = mysql_fetch_array($result2);
if( mysql_num_rows($result2) < 1 )
{
echo "less than one inside of nothing found.";
}
Else
{
$USER[$id]["bannerID"] = $RS2["bannerID"];
$USER[$id]["banner"] = $RS2["banner"];
$USER[$id]["format"] = $RS2["format"];
$USER[$id]["width"] = $RS2["width"];
$USER[$id]["height"] = $RS2["height"];
$USER[$id]["alt"] = $RS2["alt"];
$USER[$id]["url"] = $RS2["url"];
$USER[$id]["cbannerID"] = $RS2["bannerID"];
}
}
Else
{
$USER[$id]["bannerID"] = $RS["bannerID"];
$USER[$id]["banner"] = $RS["banner"];
$USER[$id]["format"] = $RS["format"];
$USER[$id]["width"] = $RS["width"];
$USER[$id]["height"] = $RS["height"];
$USER[$id]["alt"] = $RS["alt"];
$USER[$id]["url"] = $RS["url"];
$USER[$id]["cbannerID"] = $RS["bannerID"];
}
if($USER[$id]["format"] == "html")
{
echo "<center><a
href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=" .
$USER[$id]["bannerID"] . "\" target=\"_blank\">" . $USER[$id]["banner"]
. "</a></center>";
}
else
{
echo "<a
href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=" .
$USER[$id]["bannerID"] . "\" target=\"_blank\"><img
src=\"$GLOBALS[phpAds_url_prefix]/viewbanner.php3?bannerID=" .
$USER[$id]["bannerID"] . "\" width=" . $USER[$id]["width"] . " height="
. $USER[$id]["height"] . " alt=\"" . $USER[$id]["alt"] . "\"
border=0></a>";
}
//log_adview($USER[$id]["bannerID"]);
}
function view_order($keywords, $id)
{
global $phpAds_db, $phpAds_hostname, $phpAds_mysqluser, $phpAds_mysqlpassword,
$REMOTE_HOST, $USER, $phpAds_tbl_banners;
if(!isset($USER[$id]["cbannerID"])) $USER[$id]["cbannerID"] = -1;
#############################################################
$text = explode("/", $keywords);
$keywords = "";
$x = 0;
foreach($text as $line)
{
if( $x == 0 )
{
$keywords = "(keyword LIKE '%" . $line . "%'";
}
else
{
$keywords = $keywords . " OR keyword LIKE '%" . $line . "%'";
}
$x++;
}
$keywords .= ")";
#############################################################
mysql_connect($phpAds_hostname,$phpAds_mysqluser,$phpAds_mysqlpassword) 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);
if( mysql_num_rows($resultm) < 1 )
{
$num1 = rand(1, 100);
}
Else
{
$num1 = rand($RSM[0], $RSM[1]);
}
$sql = "SELECT bannerID,banner,format,width,height,alt,url FROM
$phpAds_tbl_banners WHERE active = 'true' AND $keywords AND bannerID >= $num1 ORDER BY
bannerID LIMIT 0,1;";
}
else
{
$sql = "SELECT bannerID,banner,format,width,height,alt,url FROM
$phpAds_tbl_banners WHERE active = 'true' AND $keywords AND bannerID > " .
$USER[$id]["cbannerID"] . " ORDER BY bannerID LIMIT 0,1;";
}
$result = mysql_query($sql);
$RS = mysql_fetch_array($result);
if( mysql_num_rows($result) < 1 )
{
$sql2 = "SELECT bannerID,banner,format,width,height,alt,url FROM
$phpAds_tbl_banners WHERE active = 'true' AND $keywords ORDER BY bannerID LIMIT 0,1;";
$result2 = mysql_query($sql2);
$RS2 = mysql_fetch_array($result2);
if( mysql_num_rows($result2) < 1 )
{
echo "less than one inside of nothing found.";
}
Else
{
$USER[$id]["bannerID"] = $RS2["bannerID"];
$USER[$id]["banner"] = $RS2["banner"];
$USER[$id]["format"] = $RS2["format"];
$USER[$id]["width"] = $RS2["width"];
$USER[$id]["height"] = $RS2["height"];
$USER[$id]["alt"] = $RS2["alt"];
$USER[$id]["url"] = $RS2["url"];
$USER[$id]["cbannerID"] = $RS2["bannerID"];
}
}
Else
{
$USER[$id]["bannerID"] = $RS["bannerID"];
$USER[$id]["banner"] = $RS["banner"];
$USER[$id]["format"] = $RS["format"];
$USER[$id]["width"] = $RS["width"];
$USER[$id]["height"] = $RS["height"];
$USER[$id]["alt"] = $RS["alt"];
$USER[$id]["url"] = $RS["url"];
$USER[$id]["cbannerID"] = $RS["bannerID"];
}
if($USER[$id]["format"] == "html")
{
echo "<center><a
href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=" . $USER[$id]["bannerID"] .
"\" target=\"_blank\">" . $USER[$id]["banner"] . "</a></center>";
}
else
{
echo "<a href=\"$GLOBALS[phpAds_url_prefix]/click.php3?bannerID=" .
$USER[$id]["bannerID"] . "\" target=\"_blank\"><img
src=\"$GLOBALS[phpAds_url_prefix]/viewbanner.php3?bannerID=" . $USER[$id]["bannerID"]
. "\" width=" . $USER[$id]["width"] . " height=" . $USER[$id]["height"] . " alt=\"" .
$USER[$id]["alt"] . "\" border=0></a>";
}
//log_adview($USER[$id]["bannerID"]);
}
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 267
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 269
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 287
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 289
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 295
Warning: Supplied argument is not a valid MySQL result resource in
D:\Gunks\NewSite\phpAds\view.inc.php3 on line 297
less than one inside of nothing found.
Warning: Undefined index: format in D:\Gunks\NewSite\phpAds\view.inc.php3 on line 327
Warning: Undefined index: bannerID in D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: bannerID in D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: width in D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: height in D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
Warning: Undefined index: alt in D:\Gunks\NewSite\phpAds\view.inc.php3 on line 333
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
