Can someone take a look at this and tell me why It won't submit. I feel like I have reviewed the code a million time and can't see what is wrong thnaks.
<?php
//Begin user session
session_start();
header("Cache-control: private"); //IE 6 Fix
//End Session information
require("../db/db_connect.php");
require("../funtions/checklogged.php");
include("../funtions/ecape_data.php");
if (checkLogged() != true) {
//this is a guest show login form
echo'<a href="login.php">Return to Login</a>';
exit();
} else {
//user logged in
}
$totalrows = 0;
$result = mysql_query("SELECT * FROM company ORDER BY company_name",$db);
?>
<?
if (!empty($_POST['submit']))
{//Start $_POST[]
$company = $_POST['company'];
$query = "SELECT * FROM job_out WHERE company_name = $company";
$result = mysql_query ($query, $db);
$myrow = mysql_fetch_array($result);
$totalrows = mysql_num_rows($result);
if($totalrows == 0)
{//Start check for rows
echo'There are no jobs for ', $company;
}else
{
$bgcolor = "#E0E0E0"; // light gray
echo( "<table border=1 cellpadding=0 cellspacing=0>");
echo( "<tr><td ALIGN='CENTER'><font size=-1><b>Record #</b></font></td>");
echo( "<td ALIGN='CENTER' align='center'><font size=-1><b>Company Name</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Employee Name</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Cost Center</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Job #</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Post Type</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Post Class</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Post Rate</b></font></td>");
echo( "<td ALIGN='CENTER'><font size=-1><b>Date</b></font></td></tr>\n");
while($myrow = mysql_fetch_array($result))
{
if ($bgcolor == "#E0E0E0")
{
$bgcolor = "#FFFFFF";
}else{
$bgcolor = "#E0E0E0";
}
echo("<tr bgcolor=".$bgcolor."><td align='CENTER'><font size=-1>");
echo($myrow[4]);
echo("</font></td><td align='CENTER'><font size=-1>");
echo($myrow[0]);
echo("</font></td><td align='CENTER'><font size=-1>");
echo($myrow[5]);
echo("</font></td>");
echo("<td align='CENTER'><font size=-1>");
echo($myrow[1]);
echo("</font></td>");
echo("<td align='CENTER'><font size=-1>");
echo($myrow[2]);
echo("</font></td>");
echo("<td align='CENTER'><font size=-1>");
echo($myrow[6]);
echo("</font></td>");
echo("<td align='CENTER'><font size=-1>");
echo($myrow[7]);
echo("</font></td>");
echo("<td align='CENTER'><font size=-1>");
echo($myrow[8]);
echo("</font></td>");
echo("<td align='CENTER'><font size=-1>");
echo($myrow[3]);
echo("</font></td></tr>");
}//End while for color
echo("</table>");
}//End
}else{
?>
<html>
<body>
<table cellpadding="0" cellspacing="0">
<tr>
<td><from action="<? echo $_POST['submit']; ?>" method="post">
<select name="<? if(isset($_POST['company'])) echo $_POST['company']; ?>">
<?
while ($myrow = mysql_fetch_array($result))
{
printf("<option value=\"%s\">",$myrow["company_name"]);
printf("\"%s %s\" </option>", $myrow["company_name"], $myrow["company_id"]); //$myrow["company_id"]);
}
?>
</select>
<input type="submit" name="submit" value="Find"></input>
</form></td>
</tr>
</table>
</body>
</html>
<?
}//End
?>
