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
Do While statement
hi guys,
This may sound trivial but im new to php and as part of an assignmenti have to const
Material Master Update through BAPI - Follow up material not updated
Hi Experts,
I am updating the material master through a custom transaction using the BAPI
php global variable
how can we create global variable so we can use its value in any form.. Please give example to
How do i use vars in an array
Hiya peeps!
How do I use a var in an array. You will see $id but it isnt working.
Php If in MySql query (hiding labels if a field is empty)
Okay, I've been trying to do this for a while, and I'm finally going to ask for help so I can get th
Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming
Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser
login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php
Staff Induction System - No idea where to go from here!!!
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi
phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:
Code: [Select]$mailer = new PHPMailer();
$mailer-&