SELECT *
FROM `payments`
WHERE `date` BETWEEN DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)) AND DATE(NOW());
background-image: url('<span id=" title<section class="hero" style="background-image: url('<?=SITE_TEMPLATE_PATH;?>/img/hero-bg.jpg')">
...
</section>
$query = mysql_query("INSERT INTO `subs` VALUES ($login,$pass)");
Select t1.cat_id, t1.id, t2.* from
(Select cat_id, min(id) from table group by cat_id
UNION
Select cat_id, min(id) from table
where id not in (Select min(id) from table group by cat_id) group by cat_id) t1
left join table t2 on t1.id = t2.id
