Please help me out
Wx
The following sql statements work when called from command line i.e in the php path
<?php
$link = @mysql_connect()
or die("Could not connect: " . mysql_error());
print ("Connected successfully");
// mysql_close($link);
$db = @mysql_select_db(my_database) or die(" Database Not Found:" .mysql_error());
print ("using my_database");
mysql_query("insert into table1 (std_id, std_name, stdmaj, std_new,
studentSSN, Date)
values( null, 'Kioshoere Merhi', 'International Studies', 'Junior', '26577922',
20003-07-25)");
mysql_query("insert into table2( std_id, optA, optB, optC,optD,
optE, optF, optG, optH, optJ, optL, optM)
values(0000, 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y')");
mysql_query("insert into table3(std_ID, text_opt1, text_opt2, Ins_ID)
values(0000, 'Y', 'Y', 2)");
mysql_query("insert into table4(std_id, in_id, in_name, act_text, Date)
values(0000, 1, 'text', 'text string', null)");
?>
but when called from the following form:
<html>
<title>Form</title>
<body bgcolor="#CCCCC">
<head1><font type="Courier" color="brick" size="5">Form 1</font></head>
<p><font size="4" color="beige"><marquee>Today's Date:
<?php
echo(date('l, F dS Y. '));
?>
</marquee></font></p>
<form action="ears_script.php" method="POST">
<p>
<font size="5">Student ID</font></p>
<p>
<table border="1">
<tr bgcolor="green">
<p>
<td width="80">
<font color="black" style="bold" size="4">Name: </td>
<td align="center"><input type="text" size="20" maxlenght="60" name="$std_name"
/></td></font></p>
<p>
<td width="80">
<font color="black" style="bold" size="4">Major: </td><td align="center"><input
type="text" size="20"maxlenght="60" name="$std_major" /></td></font></p>
<p>
<td width="120">
<font color="black" style="bold" size="4">SS#: </td><td align="center"><input
type="text" size="10" maxlenght="9" name="$std_ssn"/></td></font></p>
<p>
<td width="80">
<font color="black" style="bold" size="4">Class/Section: </td><td
align="center"><input type="text" size="20" maxlenght="60" name
="$std_class"/></td></font></p>
<p>
<td width="10">
<font color="black" style="bold" size="4">Date: </td><td align="center"><input
type="text" size="6" maxlenght="10" name="datestamp"/></td></font></p>
</tr>
</table>
<font color="redgreen" size="5"><td align="center"> New Heading</td></font><p>
<input type="checkbox" name="o$pt1" size="15" />Option1
<p><input type="checkbox" name="$opt2" size="15" />Option2</p>
<p><input type="checkbox" name="$opt3" size="15" />Option2</P>
<p><input type="checkbox" name="$opt4" size="15" />Option4 <input type="text"
size="15" maxlenght="3" name="number" /> Assignments</P>
<p><input type="checkbox" name="$opt5" size="15" />Option5</P>
<p><input type="checkbox" name="$opt6" size="15" />Option6</P>
<p><input type="checkbox" name="$opt7" size="15" />Option7</P>
<p><input type="checkbox" name="$opt8" size="15" />Option8</P>
<p><input type="checkbox" name="$opt9" size="15" />Option9</P>
<p><input type="checkbox" name="$optA" size="15" />OptionA</P>
<p><input type="checkbox" name="$optB" size="15" />OptionB <input type="text"
name="pproblem" size="15" /></P>
<p><input type="checkbox" name="$optC" size="15" />OptionC <input type="text"
name="other" size="28" /></P>
<p><input type="checkbox" name="$optD" size="15" />OptionD</P>
<p><input type="checkbox" name="$optE" size="15" />OptE</P>
<p><head><font size="5" color="orangegreen">Text Options</font></head></p>
<p><input type="checkbox" name="$optI" size="15" />I Text Option1.</p>
<p><input type="checkbox" name="$optII size="15" />I Text Option2.</p>
<p>
<p>
<p><font size="5" position="center" color="orange">Test1</font></p><p><input
type="text" name="action_taken" size="50" maxlenght="255" />
<p>
<head2><font color="red" size="5">Content2: <input type="text"
name="$inst_name"size="40" maxlenght="60" /></head2></p>
<p>
<input type="submit" value="Upload" size="15" />
<input type="reset" name="r" value="reset" size="15" /></p>
</form>
</body>
</html>
I get this Error: Parse error: parse error, unexpected '@' in
c:\inetpub\wwwroot\DIR\my_script.php on line 18
