In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Alvin Tan") wrote:
> 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>";
> }
> }
Which of the queries are you concerned with, 'cuz on that second query
you're only fetching array $b once. Wrap a while() loop around it like
you did with array $a if you want more rows.
BTW, you're missing an opening curly brace for the first while().
--
CC
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]