[RESOLVED] really stuck on this one.

[rbblue8]

hey,

I have a need to do the following.

i have a form with a drop down menue. That drop down menue contains a list of numbers. based on the users selection (lets say they choose three) that amount of tables are created with data auto populated (in this case three tables). Some of the data in the three tables contains data from another mysql query (that has not been processed yet). I need to process the data from the 2nd mysql query and repeat it in all the tables that are generated.

here is what i have so far.

//first lets push the num of people into an array!
		if($_POST['team_num_people'] == '2')$num_people=array("1");
		if($_POST['team_num_people'] == '3')$num_people=array("1", "2");
		if($_POST['team_num_people'] == '4')$num_people=array("1", "2", "3");
		if($_POST['team_num_people'] == '5')$num_people=array("1", "2", "3", "4");
		if($_POST['team_num_people'] == '6')$num_people=array("1", "2", "3", "4", "5");
		if($_POST['team_num_people'] == '7')$num_people=array("1", "2", "3", "4", "5", "6");
		if($_POST['team_num_people'] == '8')$num_people=array("1", "2", "3", "4", "5", "6", "7");

	//now lets get a list of all the users
	require ('pages/armada_mysql.php');
	$string=("SELECT username FROM users WHERE username NOT LIKE '".$username."' 
	ORDER BY 'username' DESC");
	$query=mysql_query($string, $armada);
	if(!$query)
		{//start of if statment (throw error)
		$code='17';
		require('pages/error.php');
		}//end of if statment (throw error)
	$result=mysql_fetch_assoc($query);

	if(!isset($error))
	foreach($num_people as $value)
		{//start of foreach
		echo'
			<table width="250" border="2">
			<tr>
				 <td>Username</td>
				 <td>
				 <select name="users[]" id="users[]">';
				 foreach($result as $test)
				 {
				 echo'<option value="'.$test.'">'.$test.'</option>';
				 }
				 echo'
				 </select>
				 </td>
			</tr>
			<tr>
				<td>Team</td>
				<td>
				<select name="team[]" id="team[]">
				<option value="Team1">Team 1</option>
				<option value="Team2">Team 2</option>
				<option value="Team3">Team 3</option>
				<option value="Team4">Team 4</option>
				</select>
				</td>
			</tr>
			<tr>
				<td>Race</td>
				<td>
				<select name="race[]" id="race[]">
				<option value="Borg">Borg</option>
				<option value="Cardassians">Cardassians</option>
				<option value="Federation">Federation</option>
				<option value="Klingons">Klingons</option>
				<option value="Romulans">Romulans</option>
				<option value="Species 8472">Species 8472</option>
				</select>
			</tr>
			</table>
			<br /><br />';
		}//end of foreach

this only pulls out the first result from the mysql query and posts it every where it's supposed to be. when there should be tons of results.

[rbblue8]

I solved it...

i added the following the code

while($result=mysql_fetch_row($query))
						 {//while
						 foreach($result as $value1)
						 	{//foreach
						 	$data4[]='<option value="'.$value1.'">'.$value1.'</option>';
						 	}//end foreach
						 }//end while

foreach ($data4 as $test6)echo $test6;

with an end result of this.

[code=php]

//if it's a team game... display the team page
if(isset($POST['team_yes']) and !isset($POST['team_no']) and !isset($error))
{//start of if statment (display team page)

	//first lets push the num of people into an array!
	if($_POST['team_num_people'] == '2')$num_people=array("1");
	if($_POST['team_num_people'] == '3')$num_people=array("1", "2");
	if($_POST['team_num_people'] == '4')$num_people=array("1", "2", "3");
	if($_POST['team_num_people'] == '5')$num_people=array("1", "2", "3", "4");
	if($_POST['team_num_people'] == '6')$num_people=array("1", "2", "3", "4", "5");
	if($_POST['team_num_people'] == '7')$num_people=array("1", "2", "3", "4", "5", "6");
	if($_POST['team_num_people'] == '8')$num_people=array("1", "2", "3", "4", "5", "6", "7");

	//now lets get a list of all the users
	require ('pages/armada_mysql.php');
	$string=("SELECT username FROM users WHERE username NOT LIKE '$username'
	ORDER BY 'username' DESC");
	$query=mysql_query($string, $armada);
	if(!$query)
		{//start of if statment (throw error)
		$code='17';
		require('pages/error.php');
		}//end of if statment (throw error)
				while($result=mysql_fetch_row($query))
					 {//while
					 foreach($result as $value1)
					 	{//foreach
					 	$data4[]='<option value="'.$value1.'">'.$value1.'</option>';
					 	}//end foreach
					 }//end while


	if(!isset($error))
	foreach($num_people as $value)
		{//start of foreach
		$count=$value+1;
		echo'
			<table width="250" border="2">
			<tr>
				<td colspan="2">Player'.$count.'</td>
			</tr>
			<tr>
				 <td>Username</td>
				 <td>
				 <select name="users[]" id="users[]">';
				foreach ($data4 as $test6)echo $test6;
				 echo'
				 </select>
				 </td>
			</tr>
			<tr>
				<td>Team</td>
				<td>
				<select name="team[]" id="team[]">
				<option value="Team1">Team 1</option>
				<option value="Team2">Team 2</option>
				<option value="Team3">Team 3</option>
				<option value="Team4">Team 4</option>
				</select>
				</td>
			</tr>
			<tr>
				<td>Race</td>
				<td>
				<select name="race[]" id="race[]">
				<option value="Borg">Borg</option>
				<option value="Cardassians">Cardassians</option>
				<option value="Federation">Federation</option>
				<option value="Klingons">Klingons</option>
				<option value="Romulans">Romulans</option>
				<option value="Species 8472">Species 8472</option>
				</select>
			</tr>
			</table>[/code]

and the displays the data where it's needed. 🙂