Hi Jeremy,... 
I got table field "dob" with default value NULL,... and it works,... 

ALTER TABLE `users` 
  ADD   `dob` text default NULL; 

and here is how I'm adding that field in a controller: 
        $this->data['User']['dob'] = 
$this->data['User']['birthday']['month'] . '-' . 
$this->data['User']['birthday']['day'];

it works perfect,... :) 
now I need to figure out how to find friends list and send emails to each 
one of them when the birthday is reached,... 

thank you for your help,... 
        


On Saturday, June 22, 2013 1:35:59 PM UTC-7, Jeremy Burns wrote:
>
> Have you thought about adding month and day fields to the table and 
> populating them beforeSave? Less processing required when you want to run 
> your cron job.
>
> Jeremy Burns
> Class Outfit
>
> http://www.classoutfit.com 
>
> On 22 Jun 2013, at 21:13:01, Chris <[email protected] <javascript:>> 
> wrote:
>
> Hi guys,... can anyone help me please
> Ho w can I illuminate (remove) Year in "birthday" field from users table? 
> The concept is to find ONLY Month and Day (e.g. 06-21) from 1964-06-21 
> I'm doing this cronjob feature to send email to friends of a user once the 
> Birthday is reached... e.g. $this->Email->subject = 
> ucfirst(i18n::translate('your friend'))  . ' : ' . 
> $user['User']['firstname'] . ' ' . ucfirst(i18n::translate('celebrating 
> birthday')); on a Social Network site. 
>
> thanks in advance 
> chris
>
> -- 
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>  
> --- 
> You received this message because you are subscribed to the Google Groups 
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to [email protected] <javascript:>.
> To post to this group, send email to [email protected]<javascript:>
> .
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to