Hello, can someone please help me??
I am getting this error:
Parse error: parse error, unexpected $ in c:\inetpub\wwwroot\updatesymm4.php on line 139
line 139 is the last line and there is no "unexpected $" - what am I doing wrong??
here's the code:
<?php
include 'db.php';
include 'error.php';
//Initialise an error string
//$errorString = "";
//Clean and trim the posted values
$MCC = $HTTP_GET_VARS["MCC"];
//Has MCC been provided?
//Validate the MCC
if (!empty($MCC))
{
if(!($connection = @mysql_connect("localhost", "$user","$password")))
die("Could not connect to database");
if(!mysql_select_db("emc"))
showerror();
// create query
$query = "SELECT * FROM symms WHERE MCC = " . $MCC;
if(!($result = @msql_query($query)))
showerror();
$row = mysql_fetch_array($result);
//Reset $formVars, since we're loading from the symm table
$formVars = array();
//Load all the form variables with symm data
$formVars["Engineer"] = $row["Engineer"];
$formVars["MCC"] = $row["MCC"];
$formVars["Serial"] = $row["Serial"];
$formVars["Type"] = $row["Type"];
$formVars["IP_Address"] = $row["IP_Address"];
$formVars["EA"] = $row["EA"];
$formVars["FA"] = $row["FA"];
$formVars["EF"] = $row["EF"];
$formVars["RDF"] = $row["RDF"];
$formVars["PAV"] = $row["PAV"];
$formVars["RAID"] = $row["RAID"];
?>
<!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><title>Symm Details</title></head>
<body>
<form method="post" action="SymmUpdate.php">
<h1>Symm Details</h1>
<h3>Please change the field(s) you wish to update. Fields in <font color="#FF0000">red</font> are mandatory</h3>
<table>
<col span="1" align="right">
<tr>
<td><input type = "hidden" name="MCC" value ="<?php echo $MCC;?>"></td>
</tr>
<tr>
<td><font color="#ff0000">Engineer:</font></td>
<td><input type="Text" name="Engineer" value="<?php echo $formVars["Engineer"];?>" size =50> </td>
</tr>
<tr>
<td><font color="#ff0000">Serial:</font></td>
<td><input type="Text" name="Serial" value="<?php echo $formVars["Serial"];?>" size =50> </td>
</tr>
<tr>
<td><font color="#ff0000">Symm Type:</font></td>
<td><select name="Type" value="<?php echo $formVars["Type"];?>">
<option value="6.0 TF">6.0 TF</option>
<option value="LEOPARD">LEOPARD</option>
<option value="PANTHER">PANTHER</option>
<option value="RHINO">RHINO</option>
<option value="RMS">RMS</option>
</select> </td>
</tr>
<tr>
<td><font color="#ff0000">IP_Address:</font></td>
<td><input type="Text" name="IP_Address" value="<?php echo $formVars["IP_Address"];?>" size =50> </td>
</tr>
<tr>
<td>EA:</td>
<td><input type="checkbox" name="EA" id="EA" value="<?php echo $formVars["EA"];?>" > </td>
</tr>
<tr>
<td>FA:</td>
<td><input type="checkbox" name="FA" id="FA" value="<?php echo $formVars["FA"];?>" > </td>
</tr>
<tr>
<td>EF:</td>
<td><input type="checkbox" name="EF" id="EF" value="<?php echo $formVars["EF"];?>" > </td>
</tr>
<tr>
<td>RDF:</td>
<td><input type="checkbox" name="RDF" id="RDF" value="<?php echo $formVars["RDF"];?>" > </td>
</tr>
<tr>
<td>PAV:</td>
<td><input type="checkbox" name="PAV" id="PAV" value="<?php echo $formVars["PAV"];?>" > </td>
</tr>
<tr>
<td><font color="BLACK">RAID:</font></td>
<td><select name="RAID" id="RAID" value="<?php echo $formVars["RAID"];?>">
<option value="NONE" SELECTED>NONE</option>
<option value="RAID 3">RAID 3</option>
<option value="RAID 5">RAID 5</option>
<option value="RAID 7">RAID 7</option></td>
</tr>
<tr>
<td><br><br><input type="submit" name="SUBMIT" value="Update SYMM"></td>
</tr>
</table>
</form>
</body></html>
