Having a problem get the selected item from a drop down menu

Posted on 16th Feb 2014 07:03 pm by admin

I have been looking at this for days now.

I have a drop down menu that get it's values from an sql database That works but now I want to get the item and pass it to another query that's where I get lost or I may have been lost from the start and got lucky.

Here is the code I have
Code: [Select] <form action="" method="post" name="test"></form>

<select name="flt_game" id="flt_game" onChange="document.test.submit();">

<?php

$sql2 = "SELECT Pilot_Number, Pilot_Name FROM Logger_pilots ORDER BY Pilot_Number";
$result2 = $db->
sql_query($sql2);
while ($row = $db->sql_fetchrow($result2)) {
$pilotid = $row[Pilot_Number];
$pilot1 = $row[Pilot_Name];
if ($pilotid == $pilot1) {
$sel = "selected ";

}
echo "<option $sel value="$pilot1">$pilot1</option>






n";
$sel = "";


}




?>
</select>
</form>
<?php
echo "You selected $sel ";
echo "

";
echo "<b>A/A Kill Average By Aircraft `flt_game`</b>

</center>";

$a = 1;


$sql5 = "SELECT Pilot_Name AS pilot , Aircraft AS aircraft1 , round((SUM(Kills) / SUM(Killed))*1,2) AS hrs FROM logger_stats WHERE Pilot_Name = '$pilot1' GROUP BY Pilot_Name, Aircraft ORDER BY hrs DESC LIMIT 0,100";

$result5=sql_query($sql5, $db);
while(list($pilot, $aircraft1, $hrs) = sql_fetch_row($result5, $db)) {

echo "<font color="#CC9900" >$a:&nbsp;&nbsp;$aircraft1&nbsp;&nbsp;</font><em>($hrs Kills)</em>
";
$a++;
}

Thanks For the Help

Your Answer:

Login to answer

Other forums

Problem with "dynamic" index page
Hi. I have one question. In my index.php page I have this kind of code:
Code: // listaa sivut

displaying email without attracting a ton of spam
Hello,

this is maybe the wrong place to ask.
How would you display an email address on a w

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi

Not "Just Another" MMORPG - text based.
Hello,

I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus

Warehouse Management
Hi,

On our system, we have two storage locations ( A and B ) where A is the main factory

Printer configuration
Hi All,
Suppose one of the user deleted the printer settings unfortunatly ,then what is the pro

Display certain image depending on time of year
Hi, I am new to these forums and would really appreciate some advice on a piece of coding I have don

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a