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

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo

Delete Client 066 Earlywatch
Hi all,

in former times client earlywatch was required for SAPs remote access to SAP inst

Is there something wrong?
Hi all,

Just a quick question... can someone look at this code and see if something is wrong?

Array disappearing in foreach loop
Okay, I have this problem where an array will become undefined in a foreach loop.

Here is the

form class help (oop php5)
Hidy Ho Neighbors,

I'm forcing myself to learn oop/classes for php5. It seems like a good id

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else

I can give them an F

Collecting AOL Search Terms
I am attempting to collect AOL search terms. I know the code is correct (it works for google, bing,

How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can