assistance file update

En curso Publicado hace 5 años Pagado a la entrega
En curso Pagado a la entrega

I need to update the query

Substract from todays date the date on my DB in order to show the customers that are with their payments up to date

I can send file or share github address

[login to view URL]

//original query

$query = mysqli_query($mysqli,"SELECT * FROM registrados WHERE actividad = " . $fetch_actividad['id_actividad'] . " ORDER BY apellido ASC");

// $query = mysqli_query($mysqli,"SELECT * FROM registrados WHERE actividad = " . $fetch_actividad['id_actividad'] . AND "mes_pagado between now() - interval 40 day" . " ORDER BY apellido ASC");

//$query = mysqli_query($mysqli,"SELECT * FROM registrados WHERE actividad = " . $fetch_actividad['id_actividad'] . AND CURDATE()-registrados.mes_pagado< DATE_SUB("mes_pagado", INTERVAL 40 DAY) . " ORDER BY apellido ASC");

Programación de bases de datos MySQL PHP SQL

Nº del proyecto: #18818491

Sobre el proyecto

2 propuestas Proyecto remoto Activo hace 5 años

2 freelancers están ofertando un promedio de $23 por este trabajo

ludwig333

Hi. i am a full web developer with over 5 years on freelancer.com. ****SPECIAL php Expert***** I have read your description and have interests in your project. I have rich experiences in projects similar to yours. Más

$20 USD en 1 día
(49 comentarios)
6.1
polaabc12

Hi I have got 10 years experience in Linux,MySQL, Oracle

$25 USD en 1 día
(0 comentarios)
0.0