Hello, I receive the following parse error:
"Parse error: parse error, expecting T_VARIABLE' or'$'' in /home/virtual/site123/fst/var/www/html/market_research/add_record.php on line 8"
Can you please help find the problem!? Here is the page that is causing the problem:
<html>
<head>
<title>Add Record To Database</title>
<link href="style.css" type="text/css" rel="stylesheet" />
</head>
<body>
<?php
if ( isset( $company_name ) && isset( $symbol ) && isset( $exchange ) && isset( $market_cap ) && isset( $no_shares_out ) && isset( $inst_ownership ) && isset( $52wk_high ) && isset( $52wk_low ) )
{
// check user input here!
$dberror = "";
$ret = add_to_database( $company_name, $symbol, $exchange, $market_cap, $no_shares_out, $inst_ownership, $52wk_high, $52wk_low, $dberror );
if ( ! $ret )
print "Error: $dberror<br>";
else
print "The Record Has Been Added Successfuly";
}
else
{
write_form();
}
function add_to_database( $company_name, $symbol, $exchange, $market_cap, $no_shares_out, $inst_ownership, $52wk_high, $52wk_low, &$dberror )
{
$user = "rhd";
$pass = "rhd_0914";
$db = "rushhourdirect_com";
$link = mysql_pconnect( "localhost", $user, $pass );
if ( ! $link )
{
$dberror = "Couldn't connect to MySQL server";
return false;
}
if ( ! mysql_select_db($db, $link ) )
{
$dberror = mysql_error();
return false;
}
$query = "INSERT INTO market_research ( company_name, symbol, exchange, market_cap, no_shares_out, inst_ownership, 52wk_high, 52wk_low )
values( '$company_name', '$symbol', '$exchange', '$market_cap', '$no_shares_out', '$inst_ownership', '$52wk_high', '$52wk_low', )";
if ( ! mysql_query( $query, $link ) )
{
$dberror = mysql_error();
return false;
}
return true;
}
function write_form()
{
global $PHP_SELF;
print "
<form action=\"$PHP_SELF\" method=\"POST\">
<br><br><br><br><br>
<table border=\"0\" cellpadding=\"1\" cellspacing=\"0\" align=\"center\" width=\"300\">
<tr>
<td colspan=\"2\"></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td valign=\"top\">
<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\">
<tr>
<th align=\"right\"> </th>
<th align=\"left\" valign=\"bottom\" colspan=\"7\"><span class=\"smallfontreverse\"> <b>General
Company Information</b></span></th>
</tr>
<tr bgcolor=\"#cccccc\">
<td align=\"right\"> </td>
<td><span class=\"smallprompt\">The following attributes are mandatory, but only have to
be entered once through out the entire recording period of the stock -
fields marked with an are required</span></td>
<td align=\"right\"> </td>
</tr>
</table>
<table width=\"100%\" border=\"1\" cellpadding=\"1\" cellspacing=\"0\" rules=\"rows\"
frame=\"below\" bordercolor=\"#cccccc\" bordercolordark=\"white\">
<tr>
<td colspan=\"7\"><br></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td></td>
<td align=\"left\">Company Name:</td>
<td align=\"right\"><input type=\"text\" name=\"company_name\" size=\"20\"></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td></td>
<td align=\"left\">Stock Symbol:</td>
<td align=\"right\">US:<input type=\"text\" name=\"sybmol\" size=\"5\"></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td></td>
<td align=\"left\">Exchange:</td>
<td align=\"right\">
<select name=\"exchange\">
<option value=\"NA\">US Markets:
<option value=\"AMEX\">AMEX
<option value=\"NASDAQ\">NASDAQ
<option value=\"NYSE\">NYSE</td>
</tr>
<tr>
<td bordercolor=\"#ffffff\" colspan=\"7\"><br></td>
</tr>
</table>
<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\">
<tr>
<th align=\"right\"> </th>
<th align=\"left\" valign=\"bottom\" colspan=\"7\"><span class=\"smallfontreverse\"> <b>
Fundamental Data</b></span></th>
</tr>
<tr bgcolor=\"#cccccc\">
<td align=\"right\"> </td>
<td><span class=\"smallprompt\">The following attributes are mandatory, but only have to
be entered once through out the entire recording period of the stock -
fields marked with an * are required</span></td>
<td align=\"right\"> </td>
</tr>
</table>
<table width=\"100%\" border=\"1\" cellpadding=\"1\" cellspacing=\"0\" rules=\"rows\"
frame=\"below\" bordercolor=\"#cccccc\" bordercolordark=\"white\">
<tr>
<td colspan=\"7\"><br></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td>?</td>
<td align=\"left\">Market Capitalization:</td>
<td align=\"right\"><input type=\"text\" name=\"market_cap\" size=\"15\"></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td>?</td>
<td align=\"left\">Number of Shares Out:</td>
<td align=\"right\"><input type=\"text\" name=\"no_shares_out\" size=\"15\"></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td>?</td>
<td align=\"left\">Institution Ownership:</td>
<td align=\"right\"><input type=\"text\" name=\"inst_ownership\" size=\"4\">%</td>
</tr>
<tr>
<td align=\"right\"> </td>
<td>?</td>
<td align=\"left\">52 Week High:</td>
<td align=\"right\">$ <input type=\"text\" name=\"52wk_high\" size=\"4\"></td>
</tr>
<tr>
<td align=\"right\"> </td>
<td>?</td>
<td align=\"left\">52 Week Low:</td>
<td align=\"right\">$ <input type=\"text\" name=\"52wk_low\" size=\"4\"></td>
</tr>
<tr>
<td align=\"right\" colspan=\"7\"><br><input type=\"submit\"
value=\"AddRecord\" class=\"pushbutton\"><br><br></td>
</tr>
</table>
</td>
</tr>
</table>
</form>";
}
?>
</body>
</html>
P.S. I know there is alot too look through, sorry about that, but I really appreciate your help!
Jeff
