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: $aircraft1 </font><em>($hrs Kills)</em>
";
$a++;
}
Thanks For the Help
No comments posted yet
Your Answer:
Login to answer
186
30
Other forums
Request for tunning the below query
Hi,
Can any one help me on the below query while improving the performance,
Help on Order Entry Form/System Where is best to begin.
I have a dilema and a very short amount of time at this point and I'm looking for some help on decid
Open browser page depending on XML results
Hello,
I have some PHP code that sends webbased from data to an external url ( in the form of
Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the
Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu
Help with PHP Email Script
Hi guys,
I'm a newbie to php and need help with the script below:
At the moment when I
Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi
Career Change into SAP
Hai
I am sajesh ,did my diploma in Mechatronics i have a 4 years of experience in
delete comma
HI,
How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr
i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
my ip is floating ip but it doesnt matter