Posted by Aaron Saray on 09/02/07 15:14

On Aug 27, 11:43 am, Steve <drum...@slightlymanic.com> wrote:
> 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 />";
>
> }
> }

First, what is your original SQL statement? I'd make sure its
checking against NULL or blank dates. Then, the very first thing
after mysql_query() is an if statement:
PSUEDOCODE:

if (mysql_num_rows()) {
do while statement;
}
else {
print 'no dates on calendar'
}

If you need help with your SQL, make sure to post it in reply :)

[Back to original message]