passing variables via form to query

[esiason14]

I'm trying to pass the player_id as a variable from a drop-down submit form to another page for use in a query.

Here is the code for the form:

$query = mysql_query("SELECT fname, lname, player_id FROM players ORDER by lname ASC");
?>
<form action=test.php method=POST>
 <input type="hidden" name="<php echo $player_id ?>" value="<php echo $player_id ?>"> <select name=players>
<?php
while ($r = mysql_fetch_array($query))
{
$fname =  $r["fname"];
$lname = $r["lname"];
$player_id = $r["player_id"];
echo "<option value=$player_id>$fname $lname</option>";
}
echo "</select>";
?>
<input type="submit" name="<php echo $player_id ?>" value="Plot Player" />
<input type="reset">
</form>

and the partial code for the output page:

$players = $_POST;

if (isset($players))
{

   $SQL = "SELECT * from playerstats ps, players p WHERE ps.player_id='$players' and p.player_id=ps.player_id and ps.year=2005"; 
   $RESULT = mysql_query($SQL);
   if ($myrow=$RESULT) {
      do {
	 $labels = $myrow["week"];
         //$data2[] =  (($row['pass_yd'] * 0.034) + ($row['pass_td'] * 6) + ($row['twopt'] * 2) + ($row['int'] * -2) + ($row['fmbl_lost'] * -2) + ($row['rush_yd'] * 0.067) + ($row['rush_td'] * 6));
         $datawk[] = $myrow["week"]; 
         $data[] = $myrow["pass_yd"]; 
         $data2[] = $myrow["pass_td"]; 
	 $lastname = $myrow["lname"];
	 $firstname = $myrow["fname"];	
         $data_names[] = $myrow["lname"]."(".$myrow["player_id"].")";
      }
	while ($myrow=$RESULT);
   }

Im trying to pass the variable for use in my graphing application. For some reason I can get it to work..See anything that may help me get it working?

[bogu]

This code should be:

$players = $_POST['players'];

In your output page add this:

echo "<pre>",print_r($_POST,1),"</pre>";

so u understand better how your POST array may look like ...

[esiason14]

The array output looks like this...its only one value, the player_id of the player.

Array ( [] => [players] => 59

[bogu]

And how many do u want? it should return only the id of the player u selected ...

And, what are this 2 good for?

<input type="hidden" name="<php echo $player_id ?>" value="<php echo $player_id ?>">
<input type="submit" name="<php echo $player_id ?>" value="Plot Player" />

Why do u add to the name the $player_id, is this the set when u submit your form, so that u know the last player u selected?
Only the last one will be returned when submiting the form, how do u expact tu return 2 elements that have the same name?

[esiason14]

bogu, yes..I only need the player_id of the selected player...although is may be nice to select 2 or 3 at a time. I guess I will work on that at a later time.

I really dont need the player_id in the input name...that was just me trying to get it to work.

[bogu]

If u want to select multiple players, this should do ...

<select name="players[]" multiple>
	<option value="1">1</option>
	<option value="2">2</option>
	<!-- .... -->
	<option value="n">n</option>
</select>

[HeyRay2]

In your line of code:

   $SQL = "SELECT * from playerstats ps, players p WHERE ps.player_id='$players' and p.player_id=ps.player_id and ps.year=2005";

You're trying to match ps.player_id to $players which is an array that was assigned from $_POST. You need to access a specific part of that array to get the value you are looking for.

You'll access the variable you want using:

   $SQL = "SELECT * from playerstats ps, players p WHERE ps.player_id='".$players['players']."' and p.player_id=ps.player_id and ps.year=2005";