PHP Datetime query how?

Question

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 tarih from table where tarih < '$date' order by tarih ASC");
while($r = mysql_fetch_assoc($sql)){
?>
    <tr><td><?php echo date("Y-m-d", $r['tarih']); ?></td>
    <td><?php echo date("H:i", $r['tarih']); ?></td></tr>
<?php
}
?>

PSA: The mysql_* functions are deprecated in PHP 5.5. It is not recommended for writing new code as it will prevent you from upgrading in the future. Instead, use either MySQLi or PDO and be a better PHP Developer. — Jason McCreary
– Jason McCreary, Commented Aug 6, 2013 at 21:16

John Conde · Accepted Answer · 2013-08-06 21:11:05Z

2

You close. Your current query is selecting older records (<). Try using >=:

$sql = mysql_query("select date from table where date >= '$date;' order by date ASC");

answered Aug 6, 2013 at 21:11

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user2658473 Over a year ago

Thank you for help but not working this code, not list records this query.

John Conde Over a year ago

Are you sure you have valid values in your database?

user2658473 Over a year ago

my date column name is "tarih" (turkish date) i edit my post now.

user2658473 Over a year ago

query listed to 2013-08-06 19:00 , 2013-08-06 19:30 timed records, but now time is 2013-08-07 00:40 .. I want only 00:38 and later time records, help me please.

user2658473 Over a year ago

$aqaq = time(); $sql = mysql_query("select tarih from table where tarih > '$aqaq;' order by tarih ASC"); Thanks for help. I solved my problem.

Collectives™ on Stack Overflow

PHP Datetime query how?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related