Completed

assistance file update

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");

Skills: Database Programming, MySQL, PHP, SQL

See more: parse file update mysql php, block level file update, generate remote assistance file, food stamp application form, snap application, snap benefits online, snap application va, apply for food stamps, commonhelp authentication system, virginia common help, food stamps, php file update, rss file update site automatically, upload file update mysql database, php upload csv file update database, javascript read file update web, vbscript excel read file update save file database, need day rig character, update html pageevery week day mysql, need day

About the Employer:
( 4 reviews ) Villa Allende, Argentina

Project ID: #18818491

Awarded to:

MikeJones915

Hi I read your requirements carefully. I have experience in php . If you give me the assignment, I will satisfy u with good result. If you want to, I can show you the source code of the tasks I have already done. More

$30 USD in 1 day
(10 Reviews)
3.2

8 freelancers are bidding on average $25 for this job

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. More

$20 USD in 1 day
(36 Reviews)
5.9
harrysart

Dear sir. I have read your description with great interest. I have experiences with many project. Also I am able to finish the task in time. If you send me a message, we can discuss more. I am waiting for your r More

$25 USD in 1 day
(56 Reviews)
5.1
valor312

Hello I have read your description carefully and I'm sure I can complete it in time perfectly. I've rich experience in Web development over 5+ years. I've good knowledge of js frameworks such as angular.js, react. More

$25 USD in 1 day
(15 Reviews)
4.3
IronencodersUSA

Estimado cliente, Por medio de la presente queremos expresarle nuestro interés en brindarle nuestros servicios de diseño y desarrollo de sistemas, plataformas, sistemas automatizados, aplicaciones móviles y página More

$19 USD in 0 days
(11 Reviews)
4.2
scar20181206

Hello dear. My name is Sel, I am a fullstack web developer. I read your text carefully and I am an expert of php framework. I am good at database design and manipulation with MySql for backend and also have much expe More

$30 USD in 1 day
(6 Reviews)
3.7
programdev0001

Hi, Sir!! PLEASE SEND FILE. AND i WILL CHECK. I am a new freelancer. You may doubt me because I have white history. BUT I have rich experience about PHP, sqlite, MySQL, node.js and python. i have been read your desc More

$25 USD in 1 day
(2 Reviews)
0.7
polaabc12

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

$25 USD in 1 day
(0 Reviews)
0.0