I am new at this and am having a problem displaying info from one company from a drop down
form action="QAQresults2.php" method="POST">
<?php
echo '<select name="CompanyName">';
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("leeair", $con);
$result = mysql_query("SELECT CompanyName FROM qaq ORDER BY CompanyName");
while($row = mysql_fetch_array($result)){
print '<option value="'.$row['id'].'">'.$row['CompanyName'].'</option>';}
{
echo "<br />";
echo '</select>';
}mysql_close($con);
?>
<input type="submit" name="submit" value="Search"/>
</form>
to a QAQresults2.php file that fills out their info from MySqL
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("leeair", $con);
$result = mysql_query("SELECT * FROM qaq");
$row = mysql_fetch_array($result);
{
echo "<br />";
}mysql_close($con);
?>
<div style="text-align: right;"><span style="font-weight: bold; text-decoration: underline;">Form
L-21</span><br />
</div>
<br />
<div style="text-align: center; text-decoration: underline;">
<h1>Lee Air Company, Inc</h1>
<h2>Quality Assurance Questionnaire</h2>
</div>
<table style="text-align: left; width: 100%;" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="width: 112px;"><span style="font-weight: bold;">Company Name:</span></td>
<td style="width: 288px;"><? echo $row['CompanyName']; ?></td>
<td style="width: 63px;">Contact: </td>
<td style="width: 451px;"><? echo $row['contact']; ?></td>
</tr>
<tr>
<td style="width: 112px;">Address:</td>
<td style="width: 288px;"><? echo $row['address']; ?></td>
<td style="width: 63px;">Title:</td>
<td style="width: 451px;"><? echo $row['title']; ?></td>
</tr>
<tr>
<td style="width: 112px;">City:</td>
<td style="width: 288px;"><? echo $row['city']; ?></td>
<td style="width: 63px;">Phone:</td>
<td style="width: 451px;"><? echo $row['phone']; ?></td>
</tr>
<tr>
<td style="width: 112px;">State:</td>
<td style="width: 288px;"><? echo $row['state']; ?></td>
<td style="width: 63px;">Fax:</td>
<td style="width: 451px;"><? echo $row['fax']; ?></td>
</tr>
<tr>
<td style="width: 112px;">Zip Code:</td>
<td style="width: 288px;"><? echo $row['ZipCode']; ?></td>
<td style="width: 63px;">e-mail:</td>
<td style="width: 451px;"><? echo $row['email']; ?></td>
</tr>
<tr>
<td style="width: 112px;" valign="middle"></td>
<td style="width: 288px;" valign="middle"></td>
<td style="width: 63px;" valign="middle">website: </td>
<td style="width: 451px;" valign="middle"><? echo $row['website']; ?></td>
</tr>
</tbody>
</table>
I know its something simple and I am looking too hard and just can't find it.
Thanks
