wilded
6/29/2017 - 7:44 AM

Clone

Clone

$sqlCreateStock = "INSERT INTO tblStock (stoProductID, stoWarID, stoStock, stoMinimumStock, stoMaximumStock, stoReorderPoint) VALUES ('$last_insert_id', (SELECT warID FROM tblWarehouses WHERE warDefault = '1' ORDER BY warID DESC LIMIT 1), '0', '$stoMinimumStockDefaultValue', '$stoMaximumStockDefaultValue', '$stoReorderPointDefaultValue')";
$dSet = $dgrid->ExecuteSql($sqlCreateStock);