[SOLVED] mysql syntax in xpdo query

30 Posts

neilness Reply #1, 15 years, 11 months ago

How would i recreate this mysql query with xpdo? I’m having trouble with the where clause, and not sure it’s even possible with xpdo...

SELECT * FROM resources_table WHERE [blue]FROM_UNIXTIME(createdon, ’%b-%d-%Y’)[/blue] = ’nov-12-2010’

MODX Staff
10,725 Posts

opengeek Reply #2, 15 years, 11 months ago

<?php
$resource = $modx->getObject('modResource', array(
    "FROM_UNIXTIME(`createdon`, '%b-%d-%Y') = 'nov-12-2010'"
));
?>

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

30 Posts

neilness Reply #3, 15 years, 11 months ago

wow, that was fast. Thanks!!