I am getting this error when I call my Form page in the browser:
Parse error: parse error in /opt/apache/htdocs/newclient.php on line 49
(49th row is "extract $row")
I have a drop down box called "Industry" which gets it's contents from the "IndName" column in the "Industry" table.
Here is the first 49+ lines of the form page followed by results page (if needed):
<head>
<title>4i dotCom - New Client Entry</title>
<STYLE TYPE="text/css">
H1 {
font-weight: bold;
font-size: 12pt;
line-height: 12pt;
font-family: verdana;
font-variant: normal;
font-style: normal;
}
BODY {
color: black;
background-color: white;
background-image:src="manual/images/4i_Logo.gif";
background-repeat: no-repeat;
font-family:verdana;
font-variant: normal;
font-style: normal;
font-weight: normal;
font-size: 10pt;
line-height: 11pt;
}
</STYLE>
</head>
<align="left"><IMG SRC="manual/images/4i_Logo.gif" ALT="4i Logo" BORDER=0>
<body>
<h1>4i dotCom - New Client Entry</h1>
<form action="http://localhost/insert_client.php" method="post">
<table border=0 font-size=8>
<tr><td>Industry</td><td>
<?
$db = @mysql_pconnect("localhost.localdomain:3306", "root", "password");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("4i_dotCom");
$results = mysql_query("SELECT IndName FROM Industry ORDER BY IndName");
echo '<select name="IndName">';
while( $row = mysql_fetch_array($results)){
extract $row;
echo "<option>$IndName\n";
}
echo '</select>';
?>
