Run a query every hour with php

0

I have the following query

$query = "UPDATE cat_marca as tabla_c
   SET tabla_c.precio = (SELECT tabla_c.precio * tabla_b.porcentaje
                         FROM   cat_concepto as tabla_a
                         INNER  JOIN cat_depreciacion as tabla_b 
                                  ON tabla_a.id_depreciacion =  tabla_b.id
                         WHERE   tabla_c.id_concepto = tabla_a.id_concepto)
WHERE  tabla_c.nombre_marca = 'neffos'"

I need to run every hour.

    
asked by emmanuel gomez toledo 23.11.2018 в 00:01
source

0 answers