para las ventas
Código PHP:
Ver original$con = mysqli("serv","user","pass","db");
$some_day = $con->real_escape_string($_GET["day"]); //i guess?
$q = $con->query("SELECT COUNT(amount) as total FROM ventas WHERE date='$some_day'");
$total = intval($q->fetch_assoc()["total"]);
resetiar:
Código PHP:
Ver original$con = mysqli("serv","user","pass","db");
$some_day = $con->real_escape_string($_GET["day"]); //i guess?
$q = $con->query("UPDATE ventas SET amount='0' WHERE date='$some_day'");