Umm, you have an "@" before the mysql_connect and mysql_select_db statements? remove these.
"Wx" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
