Is this possible?
Im recieved errors each time I try.
Is what im trying to do -
Im recieved errors each time I try.
Code:
$sql = "SELECT * FROM WS_Orders WHERE ws_john2_number2=$order_no";
&reportError("Unable to open Orders Table : " . $DB->Error()) if ($DB->Sql($sql));
while ($DB->FetchRow())
{
%row = $DB->DataHash();
$order_orderdate = $row{'orderDate'};
$order_shipvia = $row{'ws_john2_text4'};
$order_terms = $row{'ws_john2_text5'};
$order_quantity = $row{'Line_Quantity'};
$order_garmentcode = $row{'ws_john2_text1'};
$order_colour = $row{'county'};
$order_xs = $row{'XS'};
$order_s = $row{'S'};
$order_m = $row{'M'};
$order_l = $row{'L'};
$order_xl = $row{'XL'};
$order_xxl = $row{'XXL'};
$order_xxxl = $row{'XXXL'};
$sql = "SELECT * FROM Garments WHERE garmentCode=$order_garmentcode";
&reportError("Unable to open Orders Table : " . $DB->Error()) if ($DB->Sql($sql));
$DB->FetchRow();
%row2 = $DB->DataHash();
$order_origin = $row2{'CJC_Kelkoo_fabric'};
}
Is what im trying to do -