randall Reply #1, 3 months, 2 weeks ago
In Evo 1.0.5 I've a really simple MySQL query but for some reason I cannot get it to work. $rel is supplied by the snippet call but generates no results, however, if instead I hand code the date in, e.g. $release = "1985-04-01" it works.
If I echo $release (when using $rel or "1985-04-01") it correctly shows 1985-04-01 in both instances. Any ideas?
$release = $rel; // $release = "1985-04-01"; echo $release; $res = $modx->db->query( "SELECT id, released FROM `md_disk` WHERE released = '$release' ");
If I echo $release (when using $rel or "1985-04-01") it correctly shows 1985-04-01 in both instances. Any ideas?