Please Help me

[ysherazi]

I'll be really gratefull if someone can help me with this code

<form name="form1" method="post" action="">
<div align="center">
<input type="submit" name="Submit1" value="Goal">
<select name="select1" size="1">
<option value="Home Team"><-<-Home Team->-></option>
<? $query= "select id,name from players where currteam ='$home_id'";
$r3= mysql_query($query);
if($r3){
while($row= mysql_fetch_array($r3,MYSQL_NUM))
{$i = $row[0];
$n = $row[1];
echo "<option value=$i>$n</option>";
} mysql_free_result($r3);}
echo "<option value='Away Team'><-<-Away Team->-></option>";
$query= "select id,name from players where currteam ='$away_id'";
$r4= mysql_query($query);
if($r4){
while($row= mysql_fetch_array($r4,MYSQL_NUM))
{$x = $row[0];
$y = $row[1];
echo "<option value=$x>$y</option>";
} mysql_free_result($r4);}?>
</select>
<input name="textfield" type="text" size="3" value = "0">
:

<input name="textfield2" type="text" size="3" value ="0">
<select name="select2" size="1">
<option value="AwayTeam"><-<-Away Team->-></option>
<? $query= "select id,name from players where currteam ='$away_id'";
$r4= mysql_query($query);
if($r4){
while($row= mysql_fetch_array($r4,MYSQL_NUM))
{$x = $row[0];
$y = $row[1];
echo "<option value=$x>$y</option>";
} mysql_free_result($r4);}
echo "<option value='home Team'><-<-Home Team->-></option>";
$query= "select id,name from players where currteam ='$home_id'";
$r3= mysql_query($query);
if($r3){
while($row= mysql_fetch_array($r3,MYSQL_NUM))
{$x = $row[0];
$y = $row[1];
echo "<option value=$x>$y</option>";
} mysql_free_result($r3);}?>
</select>
<input type="submit" name="Submit2" value="Goal">
</div>
</form>

I want user to add a person from the drop down list and then and 1 to the reult of his site.

actually it is a form for match reuslts where I want to add the goal scorer

and when I add the result shown on test field become result +1

[chads2k2]

Try and start getting into the habit of using indintations. I took your code so you can see what I mean. Also start using name specific variable names. Makes things easier instead of your (r1, x1, y2) ... those just get confusing. For now they are fine ... but when you get 5,000+ lines of code they are just brutal. Just thought I would give some pointers out. Keep going! Your doing good.

<form name="form1" method="post" action="">
<div align="center">
<input type="submit" name="Submit1" value="Goal">
<select name="select1" size="1">
<option value="Home Team"><-<-Home Team->-></option>
<?
$query= "select id,name from players where currteam ='$home_id'";
$r3= mysql_query($query);
if($r3){
	while($row= mysql_fetch_array($r3,MYSQL_NUM))
	{
		$i = $row[0];
		$n = $row[1];
		echo "<option value=$i>$n</option>";
	}
	mysql_free_result($r3);
}

echo "<option value='Away Team'><-<-Away Team->-></option>";

$query= "select id,name from players where currteam ='$away_id'";
$r4= mysql_query($query);
if($r4){
	while($row= mysql_fetch_array($r4,MYSQL_NUM))
	{
		$x = $row[0];
		$y = $row[1];
		echo "<option value=$x>$y</option>";
	}
	mysql_free_result($r4);
}
?>
</select>

<select name="select2" size="1">
<option value="AwayTeam"><-<-Away Team->-></option>

<?
$query= "select id,name from players where currteam ='$away_id'";
$r4= mysql_query($query);
if($r4){
	while($row= mysql_fetch_array($r4,MYSQL_NUM))
	{
		$x = $row[0];
		$y = $row[1];
		echo "<option value=$x>$y</option>";
	}
	mysql_free_result($r4);
}

echo "<option value='home Team'><-<-Home Team->-></option>";

$query= "select id,name from players where currteam ='$home_id'";
$r3= mysql_query($query);
if($r3){
	while($row= mysql_fetch_array($r3,MYSQL_NUM))
	{
		$x = $row[0];
		$y = $row[1];
		echo "<option value=$x>$y</option>";
	}
	mysql_free_result($r3);
}
?>
</select>
<input type="submit" name="Submit2" value="Goal">
</div>
</form>

Chad

[ysherazi]

Thanks man I've already done it .

caio

[chads2k2]

Just checking the old posts. Figured you did just wanted to make sure. Have fun and keep coding!

Chad