Cita:
Iniciado por alvaro_trewhela 
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'");
Disculpa pero no logro dar con esto, me sale este error all to a member function real_escape_string() on resource in
Asi lo implementé, donde estaré fallando?
<?php
include('config/conexion.php');
$some_day = $conexion->real_escape_string($_GET["day"]); //i guess?
$db = $conexion->query("SELECT COUNT(amount) as total FROM sales_order WHERE date='$some_day'");
$total = intval($q->fetch_assoc()["total"]);
?>