birthdays

Hi
I have a problem I can not solve it. I have a database with date of birth.
I wanted to pull cc5 a list of one or more persons who have birthdays in the current day, but I can not find the way
thanks

Hi Fasano,

What format are the dates of birth saved in?

Bob

Hi Bob

Hi Fasano,

The try using a Condition like this

<?php
$today = date('Y-m-d');
return array( 'dob' => $today);
?>

replace dob with the name of your dob column.
Bob

Hi Bob
does not work ... returns no records

Hi Fasano,

Please turn on the CC debugger and see what MySQL query is being created. I am not sure if quotes are needed round the date string. If so then please try this:

<?php
$today = date('Y-m-d');
$today = "'{$today}'";
return array( 'dob' => $today);
?>

And, of course, no results will be returned unless you have an entry with a birthday today.

Bob

Hi Bob

sure .... I checked if there was a birthday !!!
I tried the new code but nothing.

Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `iwx3p_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `iwx3p_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'Auguri' AND `Connection`.`published` = '1'
[2] => SELECT COUNT(*) AS `visualizza.count` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`data` = '\'2015-05-16\''
[3] => SELECT `visualizza`.`cf_id` AS `visualizza.cf_id`, `visualizza`.`cf_uid` AS `visualizza.cf_uid`, `visualizza`.`cf_created` AS `visualizza.cf_created`, `visualizza`.`cf_modified` AS `visualizza.cf_modified`, `visualizza`.`cf_created_by` AS `visualizza.cf_created_by`, `visualizza`.`cf_modified_by` AS `visualizza.cf_modified_by`, `visualizza`.`cf_ipaddress` AS `visualizza.cf_ipaddress`, `visualizza`.`cf_user_id` AS `visualizza.cf_user_id`, `visualizza`.`cognome` AS `visualizza.cognome`, `visualizza`.`nome` AS `visualizza.nome`, `visualizza`.`data` AS `visualizza.data`, `visualizza`.`sesso` AS `visualizza.sesso`, `visualizza`.`comune` AS `visualizza.comune`, `visualizza`.`prov` AS `visualizza.prov`, `visualizza`.`codicefiscale` AS `visualizza.codicefiscale`, `visualizza`.`certificato` AS `visualizza.certificato`, `visualizza`.`indirizzo` AS `visualizza.indirizzo`, `visualizza`.`pv` AS `visualizza.pv`, `visualizza`.`citta` AS `visualizza.citta`, `visualizza`.`cap` AS `visualizza.cap`, `visualizza`.`telefono` AS `visualizza.telefono`, `visualizza`.`cellulare` AS `visualizza.cellulare`, `visualizza`.`mail` AS `visualizza.mail`, `visualizza`.`acconto` AS `visualizza.acconto`, `visualizza`.`accontolettere` AS `visualizza.accontolettere`, `visualizza`.`saldo` AS `visualizza.saldo`, `visualizza`.`saldolettere` AS `visualizza.saldolettere`, `visualizza`.`privacy` AS `visualizza.privacy`, `visualizza`.`accetto` AS `visualizza.accetto`, `visualizza`.`salva` AS `visualizza.salva`, `visualizza`.`reset` AS `visualizza.reset`, `visualizza`.`cognomegenitore` AS `visualizza.cognomegenitore`, `visualizza`.`nomegenitore` AS `visualizza.nomegenitore`, `visualizza`.`anno` AS `visualizza.anno`, `visualizza`.`eliminare` AS `visualizza.eliminare`, `visualizza`.`immagine` AS `visualizza.immagine`, `visualizza`.`nuovo` AS `visualizza.nuovo`, `visualizza`.`compleanno` AS `visualizza.compleanno`, `visualizza`.`modifica` AS `visualizza.modifica`, `visualizza`.`elimina` AS `visualizza.elimina`, `visualizza`.`qualifica` AS `visualizza.qualifica`, `visualizza`.`note` AS `visualizza.note`, `visualizza`.`categoria_mista` AS `visualizza.categoria_mista`, `visualizza`.`descrizione` AS `visualizza.descrizione`, `visualizza`.`fratello` AS `visualizza.fratello`, `visualizza`.`nomefratello` AS `visualizza.nomefratello` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`data` = '\'2015-05-16\'' ORDER BY `visualizza`.`cognome` LIMIT 30
)

Fasano

Hi Fasnao,

It looks as if the extra quotes are not needed.

SELECT COUNT(*) AS `visualizza.count` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`data` = '\'2015-05-16\''

Please try this in PHPMyAdmin and see what result you get:

SELECT COUNT(*) AS `visualizza.count` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`data` = '2015-05-16';

Bob

Bob excuse ... but I can not figure out what to do.

Hi Fasano,

Please open up PHPMyAdmin - probably from your site CPanel settings and copy and paste this into a new MySQL query there.

SELECT COUNT(*) AS `visualizza.count` FROM `scuolacalcio` AS `visualizza` WHERE `visualizza`.`data` = '2015-05-16';

to see if you get a result or an error message.

Bob

Hi Bob
... excuse me

Hi Bob
But excuse me .... it works but with today's date. I have to look for the date of birth which is obviously not 2015 (05/16/2015) But I just have to find the month and the day (05-16)

Hi Bob
resolved!!!!

<?php
$today = date('m-d');
return array( 'visualizza.data LIKE' => "%$today%" );
?>

Hi Fasano,

Yes, of course . . . it's obvious when you see it, must be the end of a long week.

Bob