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

Insert numbers from Barcode scanner into online php page
I have a real big problem, Here is what I'm trying to do. I have a Intermec CN3 handheld computer th

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro

Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop

Undefined variable when using $_SERVER['PHP_SELF']
Hi guyz, please suggest me something...
On first.php I have one input field NAME, and on posting

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc

Strange HTML Tag?
I recently noticed some odd HTML appear in some of the websites I host. Not all of them are run on a

I need to increse 6hours more, and i don't know how???
I need to increse 6hours more, and i don't know how???
<tr>
<t

How would I convert this into code using an if statement?
ES equals exam score m equals $mean s equals $total. I already coded my mean and total so I'm not g

Strange php code found on my website
I got hacked and the following code was placed within my files:

Code: [Select]<?
/*