checking the value of ALL variables

idontbelonghere

I'm looking to create some sort of if-else statement, where if any of the variables are a certain value, it will print their name, if NONE of them hold that value, it will print '(none)'...make any sense?

I have the first part down:

while ($school = mysql_fetch_array($result))

{

 if ($school[status] == 'Closed')

 	{

 	 print "$school[schoolname]<br>";

 	}

}

Can't get the second part, any help? Thanks, Dave

eoghain

while ($school = mysql_fetch_array($result)) { 
   if ($school[status] == 'Closed') { 
      print "$school[schoolname]<br>"; 
   } else if ($school[holiday] == 'Today') {
      print "$school[schoolname]<br>";
   }
}

That is how you'd build a standard if-else-if statement. But if you are printing out the same information for any valid result it'd be better to write it this way.

while ($school = mysql_fetch_array($result)) { 
   if ($school[status] == 'Closed' ||
       $school[holiday] == 'Today') { 
      print "$school[schoolname]<br>"; 
   }
}

The || is read as OR, so the above code does that same as the first, but you don't have to keep repeating the print part.

Char

Hey Dave,

Try this out:

$none = 0;

while ($school = mysql_fetch_array($result)) {
if ($school[status] == 'Closed') {
print "$school[schoolname]<br>";
$none = 1;
}
}

if($none == 0) {
print "none";
}

Hope that helped,
Charlotte Genevier
Webligo Group
http://www.webligo.com

eoghain

Oops, I guess I misunderstood the question. Char's solution is exactly what I would have given if I'd been paying attention. ;->