Binding recordsets to eCart
When binding a recordset to eCart on my localhost everything works fine. However when I run this on my live server $dmbc_po_itemSupplier = "".($rs_po->getColumnVal("supplier")) .""; does not bind
<?php
$rs_po = new WA_MySQLi_RS("rs_po",$dmbc_database,0);
$rs_po->setQuery("SELECT itemnumber, description, order_quantity, cost, buying_quantity, supplieritemnumber, packingorder, supplier FROM products WHERE supplier = ? AND stockstatus = 'Online' AND (stock-packed-customer_back_orders-pending_online_orders) + ((onorder) * (buying_quantity / selling_quantity)) <= reorder AND visible = 1 ORDER BY packingorder, itemnumber");
$rs_po->bindParam("s", "".(isset($_POST['supplier'])?$_POST['supplier']:"") ."", "-1"); //colname
$rs_po->execute();
?>
<?php
// WA eCart Get Info From MySQLi RS
if (("" == "") && $rs_po->TotalRows > 0) {
$Redirect_redirStr="";
if (function_exists("rel2abs")) {
$Redirect_redirStr = $Redirect_redirStr?rel2abs($Redirect_redirStr,dirname(__FILE__)):"";
}
while(!$rs_po->atEnd()) {
$dmbc_po_itemID = floatval("".($rs_po->getColumnVal("itemnumber")) ."");
$dmbc_po_itemName = "".($rs_po->getColumnVal("itemnumber")) ."";
$dmbc_po_itemDescription = "".($rs_po->getColumnVal("description")) ."";
$dmbc_po_itemThumbnail = "0";
$dmbc_po_itemWeight = floatval("0");
$dmbc_po_itemQuantity = floatval("".($rs_po->getColumnVal("order_quantity")) ."");
$dmbc_po_itemPrice = floatval("".($rs_po->getColumnVal("cost")) ."");
$dmbc_po_itemPack = floatval("".($rs_po->getColumnVal("buying_quantity")) ."");
$dmbc_po_itemSupplierItem = "".($rs_po->getColumnVal("supplieritemnumber")) ."";
$dmbc_po_itemLocation = floatval("".($rs_po->getColumnVal("packingorder")) ."");
$dmbc_po_itemSupplier = "".($rs_po->getColumnVal("supplier")) ."";
$dmbc_po->AddToCart(1, "", $dmbc_po_itemID, $dmbc_po_itemName, $dmbc_po_itemDescription, $dmbc_po_itemThumbnail, $dmbc_po_itemWeight, $dmbc_po_itemQuantity, $dmbc_po_itemPrice, $dmbc_po_itemPack, $dmbc_po_itemSupplierItem, $dmbc_po_itemLocation, $dmbc_po_itemSupplier);
$rs_po->moveNext();
}
if ($Redirect_redirStr != "") {
$dmbc_po->redirStr = $Redirect_redirStr;
}
$rs_po->moveFirst();
$rs_po->Index = 0;
}
?>