0) { $dias_a_calcular = (int)$_POST['dias']; } // 3. Crear una variable para usar en la consulta SQL $intervalo_dias = $dias_a_calcular; // --- FIN: NUEVO CÓDIGO PARA MANEJO DE DÍAS --- $status_array = array(); // --- INICIO: Consulta SQL Modificada --- // Se sustituye 'INTERVAL 15 DAY' por 'INTERVAL ' . $intervalo_dias . ' DAY' $texto_query="select po.products_id,pd.name,round(avg(valoracion),2) AS media_valoracion,count(*) AS opiniones_cero FROM ps_products_opinion po join ps_product_lang pd on (po.products_id=pd.id_product) join ps_product p on p.id_product=po.products_id where valoracion<>'' and p.active=1 and po.fec_ult_act >= CURDATE() - INTERVAL " . $intervalo_dias . " DAY and pd.name not like '%GRANDE%' and pd.name not like '%FAMILIAR%' group by 1 having opiniones_cero>4 order by 3"; // --- FIN: Consulta SQL Modificada --- $status_query = tep_db_query($texto_query); //echo $texto_query; ?> Fatal error: Uncaught Error: Undefined constant "HTML_PARAMS" in /var/www/vhosts/ncm.loading.net/admin1.ncm.loading.net/procMalasOpiniones.php:45 Stack trace: #0 {main} thrown in /var/www/vhosts/ncm.loading.net/admin1.ncm.loading.net/procMalasOpiniones.php on line 45