comparing the today's date with timestamp value

[mrjameer]

hi,

 

 

 

i have a mysql table which has 3 fields

1.id 2.username 3.time

values

1 abcd 1181027044

 

i want to fetch only those user id's and usernames whos time is equal to current date.any of your idea will be surely appreciated.

 

 

thanks

mrjameer

[Lumio]

<?php
   $today = strtotime('today');
   $sql = "SELECT `id`, `username` FROM `table` WHERE `time` >= $today";
   $res = mysql_query($sql);
   if ($res) {
      while($row = mysql_fetch_assoc($res)) {
         echo $row['username']."<br />\n";
      }
   }
?>

[mrjameer]

hi,

 

 

thanks for your reply.i have tested the code but nothing is displaying

 

 

thanks

mrjameer

 

[Lumio]

maybe this works:

<?php
   $today = strtotime('today');
   $sql = "SELECT `id`, `username` FROM `table` WHERE `time` >= $today";
   $res = mysql_query($sql);
   if (!($err = mysql_error())) {
      while($row = mysql_fetch_assoc($res)) {
         echo $row['username']."<br />\n";
      }
   }else echo $err;
?>