fazzfarrell Posted September 28, 2006 Share Posted September 28, 2006 I am getting this error:Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sites/jaguar.com/public_html/classes/IntelliCARTMX.inc.php on line 1935Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/sites/jaguar.com/public_html/classes/IntelliCARTMX.inc.php on line 1939The lines it referes to are:// Retrieve Zone Number $zoneSQL = "SELECT " . $this->zoneNumberColumn . " FROM " . $this->zoneTable; $zoneSQL.= " WHERE " . $this->zoneCountryColumn . "='" . $this->destination . "'"; [color=red]this one>>>>>>>>[/color] $zoneRS = mysql_query($zoneSQL,$conn); $row = mysql_fetch_assoc($zoneRS); $zone = $row[$this->zoneNumberColumn]; [color=red] this one>>>>>>>>[/color] mysql_free_result($zoneRS);The refering script on my page:?><?phpinclude_once(IMX_DIR . "/../Connections/jag.php");$IMX_SHIPCALC = new zoneCalc();$IMX_SHIPCALC->zoneTable = "ZoneID";$IMX_SHIPCALC->zoneNumberColumn = "Zone Number";$IMX_SHIPCALC->zoneCountryColumn = "Zone Country";$IMX_SHIPCALC->priceTable = "ZonePricing";$IMX_SHIPCALC->priceZoneColumn = "Zone";$IMX_SHIPCALC->priceWeightColumn = "Weight";$IMX_SHIPCALC->priceAmountColumn = "Price"; $IMX_SHIPCALC->destination = "AGUILLA";$IMX_SHIPCALC->weight = $HTTP_SESSION_VARS["icJag"]->col("TotalWeight");$IMX_SHIPCALC->conn = &$jag;$IMX_SHIPCALC->dbName = $database_jag;$HTTP_SESSION_VARS["icJag"]->shippingPrice = $IMX_SHIPCALC->calculate();?>Searched all over but can't find why its doing this? Link to comment https://forums.phpfreaks.com/topic/22386-php-errors/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.