Jump to content


Photo

php errors


  • Please log in to reply
No replies to this topic

#1 fazzfarrell

fazzfarrell
  • Members
  • PipPipPip
  • Advanced Member
  • 154 posts

Posted 28 September 2006 - 03:03 PM

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 . "'";

this one>>>>>>>> $zoneRS = mysql_query($zoneSQL,$conn);
$row = mysql_fetch_assoc($zoneRS);

$zone = $row[$this->zoneNumberColumn];

  this one>>>>>>>>  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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users