Cant get no results to show correctly.

wreed

When I do a query on my table I get results but when I try and do a catch for no results I get a blank page....help!

below is the code and I cannot get the No Results found to display....

	//set up the query
	$query = "SELECT EventID, EventName, STATUS, Location, DATE_FORMAT(msa_events.StartDate, '%m/%d/%y' ) StartDate, DATE_FORMAT(StartTime, '%l:%i %p') as StartTime, DATE_FORMAT(EndTime, '%l:%i %p') as EndTime, EventType, EventStatus, EventDescription, NEtID FROM msa_events WHERE EventStatus = '".$_POST['status']."' AND EventType = '".$_POST['program']."' AND STATUS = 'open' AND NEtID IS NULL";
	//$result=mysql_query($query);
	//$num=mysql_num_rows($result) or die(mysql_error());
	//echo $num;
	//mysql_close();
	$result = mysql_query($query); 

   // query good - check for results 
   $num_results = mysql_num_rows($result) or die(mysql_error());
   if ($num_results == 0) 
   { 
      echo "No Results Found";
   } 
   else 
   { 
      while($row = MySQL_fetch_array($result)) { 

	$EventID = $row['EventID'];
	$EventName = $row['EventName'];
	$StartDate = $row['StartDate'];
	$StartTime = $row['StartTime'];
	$EndTime = $row['EndTime'];

	echo "<input name='eventchoice' type='radio' value='".$EventID."'>".$EventName." ".$StartDate." ".$StartTime." ".$EndTime."<br />";
	//$i++;
	}
   }

raspberryh

Do you know if it is going into the "else" statement instead of the "if" like it should be (when you have no results)?
Try putting a print statement in your "else" to see if it's going into the "else" or not.

TobyRT

Maybe rework the statment to say:

if ($num_results > 0) {
while($row = MySQL_fetch_array($result)) { 

	$EventID = $row['EventID'];
	$EventName = $row['EventName'];
	$StartDate = $row['StartDate'];
	$StartTime = $row['StartTime'];
	$EndTime = $row['EndTime'];

	echo "<input name='eventchoice' type='radio' value='".$EventID."'>".$EventName." ".$StartDate." ".$StartTime." ".$EndTime."<br />";
	//$i++;
	}
   } 
else {

  echo 'Sorry, no Results Found';
   }

wreed

It was the if die statement on the row count.....it never would get to the if statement if there were no records.