|
|
Posted by Steve on 08/27/07 16:22
Can anyone help me with this code. What I want to do is check the DB and if
there is no result returned (by checking the date field) I want to echo "no
shows".
But no matter what I do it seems to blow through ANY if else statements I try
and if there are dates it shows them if not it is just blank.
is it as simple as my code being screwed up or am i missing something else?
Steve
while($band = mysql_fetch_array($result, MYSQL_ASSOC))
{
$change_to_time = strtotime($band[date]);
$newdate = date('m.d.Y', $change_to_time);
if (empty($band[date])) {
echo "No shows on the calendar.";
}
else {
echo "<div id=\"line1\">$newdate - $band[venue]</div>";
echo "<div id=\"line2\">$band[street] $band[city], $band[state] - <a href =
\"http://maps.google.com/maps?q=$band[street]+$band[city]+$band[state]\">Map</
a></div>";
echo "<div id=\"line3\">$band[notes]</div>";
echo "<div id=\"line4\">Time - $band[time], Cost - $band[cost]</div>";
echo "<hr />";
}
}
Navigation:
[Reply to this message]
|