[Resolved] If else parser not stopping

[lmayer4]

Morning,

I'm sure this is a simple fix but I can'e seem to make it work.

I have this report what I want it to do is look at the view and see if there is any data for today (I'm using another date here for testing but the idea is there) if there is not say so and stop processing and go on to check the next facility, so I can't use exit.

Heres what I have:

//conection info comes before this
$todays = "select * from vwYC8DayAM  WHERE  Facility = 'Brattleboro' and UpLoadDate = '04/19/2005'";
$TodaysResult=mssql_query($todays,$connection);
$num_rows=mssql_num_rows($TodaysResult);	
if ($num_rows == 0) {
// We have no results
echo "No Yardcheck Reported Today ";
} else 
// We have  results so create a table to display them
//blah blah blah
}

Whats happening is I get the no results message then it goes on to show the table data anyway. I thought I told it to stop...Obviously not.

Any thoughts?

Laura
{

[mrhappiness]

you don't have a {after the else

because of this php "believes" there is only one single stetement belonging to the else

this statement surely won't be executed

the statements below will be executed

[lmayer4]

Sorry about that I forgot to put that in the code on the forum it is in my code on my webage however. Duh kind of hard to help me when I don't post the code right. Geez. :queasy:

Thanks for catching that and for putting me on the right track. I had to clean up my code considerably. Works fine now.

Thanks again.