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
ereg_replace issue
hi there people
i have this code happening with regards to my wamp server. is this something
Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at
need help with this contact form
I made this form and I need it to read the data and write the data to a table and its not working ca
Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The
PHP arrays into arrays need help
Hello
I am trying to highlight the days on my calendar based on the dates that i have in my datab
Open/Close Links in Php
Hello, Hoping someone can inform me how I can get PHP to automatically open a set of links in a new
PHP Session Issue
I'm having an issue with one section on my website dealing with sessions. Now I know that myself and
Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are
button help
i originally had this but realised it is much easier to have a button.
Code: <?php
Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct