[RESOLVED] While Loop

[obrienkev]

Hi all,

Should the $result be placed inside the while loop or is it correct in its current position?

while($row = mysql_fetch_array($result))
{
 	 $class = $row['class_ID'];
 	 $query = "SELECT ffnumber ".
	 					"FROM training ".
	 					"WHERE class_ID = $class";
	 echo $query.'<br />';
}

$result = mysql_query($query) or die(mysql_error());

[devinemke]

all that your loop does is echo the queries. the only one that is actually going to be executed is the last one in the loop. don't know if that's what you want.

[obrienkev]

OK so for all results to be used I need to put the $result part in the while loop?

Thanks.

[devinemke]

let's back up. what are you trying to do here?

[obrienkev]

Hi,

I want to get all matching results from the query in the while loop.
If $result is outside the loop it only uses the last ffnumber looped.
If $result is in the loop then $query is echoed continuously.

Any ideas?

while($row = mysql_fetch_array($result))
{
 	 $class = $row['class_ID'];
 	 $query = "SELECT ffnumber ".
	 		"FROM training ".
	 		"WHERE class_ID = '$class'";
	 echo $query.'<br />';
}

$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);
echo '<br />RESULTS:'.$num_results.'<br />';

[bpat1434]

WHy not do:

$query = "SELECT ffnumber FROM training WHERE ";
while($row = mysql_fetch_array($result))
{
  $query .= "class_ID='".$row['class_ID']."' OR ";
}
$query = substr($query, 0, -4);
$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);
echo '<br />RESULTS:'.$num_results.'<br />';

~Brett