Option?

[Cooper94]

It isnt showing all of the flights I have booked is there something I am doing wrong?

<?php
session_start();
include 'data.php';
$result = mysql_query("select * from book WHERE username = '{$_SESSION['username']}'");
$num = mysql_num_rows($result);
$row = mysql_fetch_assoc($result);
?>
<form action="http://www.republicv.org/site1/options.php?content=pirep" method="post">
<ul><li>
If you would like to file a manual report please make sure the flight has been flown on vatsim or it will not be accepted. If you can not run our Acars System than you may contact the VP of Corparte Development at [email protected], and tell him the reason of this issue. Manual reports will be only accpeted as a last resort!</ul></li>
<table width=100%>
<tr><td colspan=2 align=center>
<select name=flight onchange="window.open(this.options[this.selectedIndex].value,'_top')">
<option>No Booked Flights</option>
<option><? echo $row['flightnum'] ?></option>
</td></tr>

[cola]

try tihs

 

<?php

session_start();

include 'data.php';

$result = mysql_query("select * from book WHERE username = '{$_SESSION['username']}'");

$num = mysql_num_rows($result);

 

?>

<form action="http://www.republicv.org/site1/options.php?content=pirep" method="post">

<ul><li>

If you would like to file a manual report please make sure the flight has been flown on vatsim or it will not be accepted. If you can not run our Acars System than you may contact the VP of Corparte Development at [email protected], and tell him the reason of this issue. Manual reports will be only accpeted as a last resort!</ul></li>

<table width=100%>

<tr><td colspan=2 align=center>

<select name=flight onchange="window.open(this.options[this.selectedIndex].value,'_top')">

<option>No Booked Flights</option>

 

 

<option><?

while ($row = mysql_fetch_array($result))

{

echo $row['flightnum'];

}?></option>

</td></tr>

[Cooper94]

Yes this works but say I have two flights booked it wont create an option for the second one it just puts both the flights in one option tag.

[.josh]

<?php
while ($row = mysql_fetch_array($result))
{
echo "<option value = '{$row['flightnum']}'>{$row['flightnum']}</option>";
}
?>
</td></tr>

[cola]

this is what u need.

 

<?php
session_start();
include 'data.php';
$result = mysql_query("select * from book WHERE username = '{$_SESSION['username']}'");
$num = mysql_num_rows($result);

?>
<form action="http://www.republicv.org/site1/options.php?content=pirep" method="post">
<ul><li>
If you would like to file a manual report please make sure the flight has been flown on vatsim or it will not be accepted. If you can not run our Acars System than you may contact the VP of Corparte Development at [email protected], and tell him the reason of this issue. Manual reports will be only accpeted as a last resort!</ul></li>
<table width=100%>
<tr><td colspan=2 align=center>
<select name=flight onchange="window.open(this.options[this.selectedIndex].value,'_top')">
<option>No Booked Flights</option>


<option><?
while ($row = mysql_fetch_array($result))
{
echo $row['flightnum']<?php
session_start();
include 'data.php';
$result = mysql_query("select * from book WHERE username = '{$_SESSION['username']}'");
$num = mysql_num_rows($result);

?>
<form action="http://www.republicv.org/site1/options.php?content=pirep" method="post">
<ul><li>
If you would like to file a manual report please make sure the flight has been flown on vatsim or it will not be accepted. If you can not run our Acars System than you may contact the VP of Corparte Development at [email protected], and tell him the reason of this issue. Manual reports will be only accpeted as a last resort!</ul></li>
<table width=100%>
<tr><td colspan=2 align=center>
<select name=flight onchange="window.open(this.options[this.selectedIndex].value,'_top')">
<option>No Booked Flights</option>


<?
while ($row = mysql_fetch_array($result))
{
echo "!<option>".$row['flightnum']."</option>";
}?>