Updating Database From PHP Forms

[oliverj777]

Hello,

 

I'm having a little trouble getting my head around my code here. Basically, I have a table based PHP form in my html page that loops and adds a new row to the table depending on my variables

 

The table itself displays the amount of 'squads' you have, the name of the individual squads, how many people are in your squad, and an 'add button':

 

Your Squads: | People | Form Button

Squad 'name' |    2/5  | Add More?

Squad 'name' |    3/5  | Add More?

Squad 'name' |    1/5  | Add More?

Etc .....

 

 

Code for this table:

      <p><strong> Add Soliders To Squads:</strong>
      <br />Soliders avalible: <? echo $solidersToAdd ?>
    
     <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
    <table width="500" border="0" cellspacing="0" cellpadding="0">
    <?PHP
$max = $squadNumbers - 1;
$i = 0;

while($i <= $max){
	$print = $i + 1;
	echo"<tr>";
	echo"<td width=\"200\" height=\"30\"><strong>Squad: ".$names_split[$i]."</strong></td>";
    	echo"<td width=\"200\" height=\"30\">".$content_split[$i]."/5</td>";

	if($content_split[$i] != 5){
		echo"<td height=\"30\">";
		echo"<input name=\"submitAdd\" type=\"submit\" class=\"SquadWeaponSelector\" 
				id=\"submitAdd_".$i."\" value=\"Add (".$solidersToAdd.")\" /></td>";
	}
	else{
		echo"<td height=\"30\">Squad is full</td>";
	}

	$i++;
}
?>
    </table>
    </form>

 

This all works fine, but its the action form I'm struggling with, what I want is to be able to add a person to the specific squad the user pushed the button for and add to the database. NOTE: my database stores the content (players in squad) like so: 2,3,1 as a varchar and I use explode to split it into an array (this is the same with my squad names too).

 

So here is a snippet of what I got at the top of my document, the form action:

 

                       

$squadNumbers = $info['squadNumbers']; // = 3 
		$squadNames = $info['squadNames'];       // = Alpha,Beta,Oscar
		$squadContent = $info['squadContent'];   // = 2,3,1

		// split the squad content \\
		$content_split = explode(",", $squadContent);

		// split the squad names \\
		$names_split = explode(",", $squadNames);

		$solidersToAdd = 3; // will soon be retrieving off DB

                     if (isset($_POST['submitAdd']) && $solidersToAdd != 0) {
			$i = 0;
			$max = $squadNumbers - 1;
			$newContentArray = array();
			while($i <= $max){
				$print = $i + 1;
				$newContentArray[whatever button was pressed] = 1 + $squadContent[whatever button was pressed];
				$i++;
			}

			//$solidersToAdd--;
			$glueContent = $_POST['submitAdd_1']; //implode(",",$newContentArray);
			$result = mysql_query("UPDATE users SET squadContent='$glueContent' WHERE username = '$username'") or die(mysql_error());
		}

 

First of, I dont know how to have a button actually pass on a value such as '+1', and I need it to talk specifically to that squad.

 

I would appreciate any help, many thanks in advance.