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

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

Why is this function returning a false value when it shouldn't be??
This is in an include file. I want it to check a value in an html form and see if it's just white s

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

Company Code for Vendors created through Business Partners
Hi, experts!

I'm trying to set up the integration between Business Partner (BP) and Vendo

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

check if string contain only a-z/A-Z
Is where any way to check if string contains only a-z/A-Z, without writing an array with all possibl

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

Format String help
I have a textbox where a person enters an application number. the application number is 10 characte

PHP template help
Ok, I don't know if anyone can help me but I am using PHP templates to make a site. I am a newbie an