function loadSale($ID)
{
$db = DB::GetConn();
$id_con = $db->quoteInto("ID = ?", $ID);
$getQuery = "SELECT * FROM `Sale` WHERE {$id_con} limit 1;";
$res = $db->query($getQuery);
$obj = $res->fetchObject();
return Sale::loadSaleFromObject($obj);
}
function getAllForBuyer($id)
{
$db = DB::GetConn();
$getQuery = "SELECT * FROM `Sale` ORDER BY `Price` DESC;";
$res = $db->query($getQuery);
//execute query
$returnSales = array();
while ($obj = $res->fetchObject()) {
array_push($returnSales, Sale::loadSaleFromObject($obj));
}
return $returnSales;
}
