PHP adding `tag` into array data

[morrisjohnny]

Okay i have four variables$team1, $team2, $team3, $team4i'm trying to see which team has be biggest number so at the moment i'm using this code.

<?phprequire("Connections/request.php");set_time_limit(0); //Run Drag Racesmysql_select_db($database_request,$request);$get=mysql_query("SELECT * FROM `league_drag` WHERE `RaceNo`=0");while($show=mysql_fetch_object($get)){	//Do Team 1	$team=mysql_fetch_object(mysql_query("SELECT * FROM `teams` WHERE `id`='$show->t1id'"));echo mysql_error();	$engine=mysql_fetch_object(mysql_query("SELECT * FROM `company_engine` WHERE `id`='$team->eid'"));echo mysql_error();	$tyre=mysql_fetch_object(mysql_query("SELECT * FROM `company_tyres` WHERE `id`='$team->wid'"));echo mysql_error();	$brake=mysql_fetch_object(mysql_query("SELECT * FROM `company_brakes` WHERE `id`='$team->bid'"));echo mysql_error();	if($engine->reliability>=rand(0,100)	{		//Engine Okay		$testVal=		if($tyre->reliability>=rand(0,100)		{			//Engine Okay			$carSpec=(($tyre->grip/100)*25)+(($engine->bhp/100)*75);			$driver=mysql_fetch_object(mysql_query("SELECT * FROM `drivers` WHERE `id`='$team->d1id'"));			$driSpec=($driver->acceleration+$driver->control)/2;			$team1=$carSpec+$driSpec;		}		else		{			$mailMsg1="Tyre Popped";			$team1=0;		}	}	else	{		$mailMsg1="Engine Blew Up";		$team1=0;	}	if(isset($mailMsg1))		mysql_query("INSERT INTO `user_messages` (`to_u`,`title`,`info`) VALUES ('$team->pid','Important Race Message','$mailMsg1')");			//Do Team 2	$team=mysql_fetch_object(mysql_query("SELECT * FROM `teams` WHERE `id`='$show->t2id'"));	$engine=mysql_fetch_object(mysql_query("SELECT * FROM `company_engine` WHERE `id`='$team->eid'"));	$tyre=mysql_fetch_object(mysql_query("SELECT * FROM `company_tyres` WHERE `id`='$team->wid'"));	$brake=mysql_fetch_object(mysql_query("SELECT * FROM `company_brakes` WHERE `id`='$team->bid'"));	if($engine->reliability>=rand(0,100))	{		//Engine Okay		if($tyre->reliability>=rand(0,100))		{			//Engine Okay			$carSpec=(($tyre->grip/100)*25)+(($engine->bhp/100)*75);			$driver=mysql_fetch_object(mysql_query("SELECT * FROM `drivers` WHERE `id`='$team->d1id'"));			$driSpec=($driver->acceleration+$driver->control)/2;			$team2=$carSpec+$driSpec;		}		else		{			$mailMsg2="Tyre Popped";			$team2=0;		}	}	else	{		$mailMsg2="Engine Blew Up";		$team2=0;	}	if(isset($mailMsg2))		mysql_query("INSERT INTO `user_messages` (`to_u`,`title`,`info`) VALUES ('$team->pid','Important Race Message','$mailMsg2')");			//Do Team 3	$team=mysql_fetch_object(mysql_query("SELECT * FROM `teams` WHERE `id`='$show->t3id'"));	$engine=mysql_fetch_object(mysql_query("SELECT * FROM `company_engine` WHERE `id`='$team->eid'"));	$tyre=mysql_fetch_object(mysql_query("SELECT * FROM `company_tyres` WHERE `id`='$team->wid'"));	$brake=mysql_fetch_object(mysql_query("SELECT * FROM `company_brakes` WHERE `id`='$team->bid'"));	if($engine->reliability>=rand(0,100))	{		//Engine Okay		if($tyre->reliability>=rand(0,100))		{			//Engine Okay			$carSpec=(($tyre->grip/100)*25)+(($engine->bhp/100)*75);			$driver=mysql_fetch_object(mysql_query("SELECT * FROM `drivers` WHERE `id`='$team->d1id'"));			$driSpec=($driver->acceleration+$driver->control)/2;			$team3=$carSpec+$driSpec;		}		else		{			$mailMsg3="Tyre Popped";			$team3=0;		}	}	else	{		$mailMsg3="Engine Blew Up";		$team3=0;	}	if(isset($mailMsg3))		mysql_query("INSERT INTO `user_messages` (`to_u`,`title`,`info`) VALUES ('$team->pid','Important Race Message','$mailMsg3')");			//Do Team 4	$team=mysql_fetch_object(mysql_query("SELECT * FROM `teams` WHERE `id`='$show->t4id'"));	$engine=mysql_fetch_object(mysql_query("SELECT * FROM `company_engine` WHERE `id`='$team->eid'"));	$tyre=mysql_fetch_object(mysql_query("SELECT * FROM `company_tyres` WHERE `id`='$team->wid'"));	$brake=mysql_fetch_object(mysql_query("SELECT * FROM `company_brakes` WHERE `id`='$team->bid'"));	if($engine->reliability>=rand(0,100))	{		//Engine Okay		if($tyre->reliability>=rand(0,100))		{			//Engine Okay			$carSpec=(($tyre->grip/100)*25)+(($engine->bhp/100)*75);			$driver=mysql_fetch_object(mysql_query("SELECT * FROM `drivers` WHERE `id`='$team->d1id'"));			$driSpec=($driver->acceleration+$driver->control)/2;			$team4=$carSpec+$driSpec;		}		else		{			$mailMsg4="Tyre Popped";			$team4=0;		}	}	else	{		$mailMsg4="Engine Blew Up";		$team4=0;	}	if(isset($mailMsg4))		mysql_query("INSERT INTO `user_messages` (`to_u`,`title`,`info`) VALUES ('$team->pid','Important Race Message','$mailMsg4')");			//Print Out Each Teams Variables	echo '<br />Team1:'.$team1;	if(isset($mailMsg1))		echo '<strong>'.$mailMsg1.'</strong>';	echo '<br />Team2:'.$team2;	if(isset($mailMsg2))		echo '<strong>'.$mailMsg2.'</strong>';	echo '<br />Team3:'.$team3;	if(isset($mailMsg3))		echo '<strong>'.$mailMsg3.'</strong>';	echo '<br />Team4:'.$team4;	if(isset($mailMsg4))		echo '<strong>'.$mailMsg4.'</strong>';	echo '<br />';		$myarray = array($team1,$team2,$team3,$team4);	sort($myarray);	print_r($myarray);		//Finished First	echo'<br />';	if($myarray[3]==$team4)		echo 'Team 4 Wins';	else if($myarray[3]==$team3)		echo 'Team 3 Wins';	else if($myarray[3]==$team2)		echo 'Team 2 Wins';	else if($myarray[3]==$team1)		echo 'Team 1 Wins';	echo'<br />';//Finshed Second	if($myarray[2]==$team4)		echo 'Team 4 Second';	else if($myarray[2]==$team3)		echo 'Team 3 Second';	else if($myarray[2]==$team2)		echo 'Team 2 Second';	else if($myarray[2]==$team1)		echo 'Team 1 Second';	echo'<br />';//Finshed Third		if($myarray[1]==$team1)		echo 'Team 1 Third';	else if($myarray[1]==$team2)		echo 'Team 2 Third';	else if($myarray[1]==$team3)		echo 'Team 3 Third';	else if($myarray[1]==$team4)		echo 'Team 4 Third';	echo'<br />';//Finshed Fourth	if($myarray[0]==$team4)		echo 'Team 4 Last';	else if($myarray[0]==$team3)		echo 'Team 3 Last';	else if($myarray[0]==$team2)		echo 'Team 2 Last';	else if($myarray[0]==$team1)		echo 'Team 1 Last';}?>

[justsomeguy]

You may want to store everything in an associative array so you can tell which team has which score, then use asort to sort and keep the index association, array_reverse to put the winner first instead of last, and then loop through the array to print each position.http://www.php.net/manual/en/function.asort.php