Jump to content

php errors


fazzfarrell

Recommended Posts

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 1935

Warning: 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 1939

The 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:

?>
<?php
include_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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.