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

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

Creating a unique 'control panel' for each user
Hi there,

I'm thinking of designing a site that will allow users to sign up and have their ow

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

email CODING Problem
Email coding problem.

I need to send a section of the info to $tf and the same as a Cc to $em

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.

I have images like this:

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

HTML Viewer HIDE scrollbar
How can I disable scrollbars in a HTML Viewer control? I can't hide them. Even i have enough space b