read DB - datatime conditions

livingwebstudio 29 Apr, 2017

Hi,
I would like to insert a conditions in my db read.. I have a table with a datatime value and I want to select only row with datatime major than X

<?php
$data='2017-04-26';
 return array("strtotime:(datainizio) > {strtotime($data)}");

this condition doesn't work....

Max_admin 29 Apr, 2017

Hi livingwebstudio,

Please try this:


<?php
$data='2017-04-26';
return array("datainizio >" => strtotime($data));

I assumed that your table field name is "datainizio"

Best regards,
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.