Problem with a WHILE in a FOREACH

ViperSBT

$st = $_POST['states'];
$clubcount = 0;

foreach ($st as $key => $value) {
	echo "key = ".$key." & value = ".$value."<br>";
	while($row = mysql_fetch_assoc($clubresult)){
  if ($row['state'] == $value) {
  	echo $row['cname']."<br>";
  	$clubcount++;
  	}
	}
}
echo "Total Clubs in Search: ".$clubcount;

Seems simple enough, but my result is:

key = 0 & value = 3
Club 1
Club 2
Club 3
key = 1 & value = 30
Total Clubs in Search: 3

$row definitely has clubs with a state value of 30. So it appears that it is going through the foreach the second time for the $st value, but the while doesn't seem to be processing.

I am using this script to build a table that will list all clubs within a given state or states. So I am able to get the user to select the state(s) they want to report from, and then pass it to this script. In this example I am trying to report on two states (3 = arizona and 30 = nevada) but it is only handling the while for arizona.

Drakla

it's because you've already 'exhausted' the results of the query during the first loop - either use data seek at the end to rewind it, or first of all grab the contents of the query into an array, and use array functions to compare $value against it.

gufmn

Are these values coming from a dropdown menu? If so, does it allow multiple selections?

ViperSBT

Thanks for getting my mind pointed in the right direction. I changed the code to look like this and it works great:

$st = $_POST['states'];
$clubcount = 0;

foreach ($st as $area) {
	$sql = "SELECT c.cnumber, c.cname, c.owner, c.website, h.fname, h.lname, h.street1, h.city, h.state, h.zip, h.email, h.phone, h.conphone, h.conemail, h.conmail FROM clubs c JOIN handler h ON h.hnumber = c.owner WHERE h.state = $area && c.payment =  'processed'";
	$clubresult = mysql_query($sql);
	echo $statelist[$area]."<br>";
	while($club = mysql_fetch_assoc($clubresult)) {
		echo $club['cname']."<br>";
		$clubcount++;
		}
	}