PHP Datetime query how?
Sorry my English a little, My date column is 1375801584 valuable epoch
format. I wanna only select now and next time records, i want hide history
times record. eg: 19:45 and later.
<?php
$sql = mysql_query("select date from table where date < '$date;'
order by date ASC");
while($r = mysql_fetch_assoc($sql)){;
?>
<tr><td><?=date("Y-m-d", $r['date'])?></td>
<td><?=date("H:i", $r['date']);?></td></tr>
<?php
}
?>
No comments:
Post a Comment