dates
| From: | Alvin Tan | Date: | Mon, 16 Apr 2001 07:20:41 +0000 |
| Subject: | dates | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-48712@lists.php.net to get a copy of this message | ||
hi all,
a little stuck here. trying to pull a bunch of unix timestamps out and show
only those that show up today. problem is that when i hit the first match,
the rest of the dates don't show. code follows:
======================
$sql = "SELECT * FROM dates";
$result = mysql_query($sql) or mysql_die();
while ($a = mysql_fetch_array($result))
$showsID = $a[showsID];
$ts = $a[timestamp];
$endTime=(spanDay ($ts)); // function that adds 24hrs to initial stamp to
make the end of day time.
$today = time();
if (($endTime >= $today)&&($ts <= $today))
{
$sq = "SELECT * FROM shows WHERE id=$showsID";
$result = mysql_query($sq) or mysql_die();
$b = mysql_fetch_array($result);
print "<br><font color=red>$b[name]</font><br>";
}
}
======================
thanks in advance,
@lvin