Jump to content

Archived

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

fazzfarrell

php errors

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?

Share this post


Link to post
Share on other sites

×

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.