Quotes: $_POST['testField'] _________________________ ----- Original Message ----- From: <Remember14a@xxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Saturday, February 07, 2004 20:36 Subject: Question > Dear friends, > > On submitting form to mysql database I get a parse error,There is no problem > with connection code, Problem is some where around create the sql statement > Can any one figure out where is the precise error, please. > Following is the code from php file > > <?php > // open the connection > $conn = mysql_connect("localhost", "", ""); > > // pick the database to use > mysql_select_db("testDB",$conn); > > // create the SQL statement > $sql = "INSERT INTO testtable values ('{$_POST[testField]}',' > {$_POST[testFielda]}','{$_POST[testFieldb]}','{$_POST[testFieldd]}',' > {$_POST[testFieldc]}','{$_POST[testFielde]}')"; > > > > // execute the SQL statement > if (mysql_query($sql, $conn)) { > echo "record added!"; > } else { > echo "something went wrong"; > } > ?> > -------------------------------------------------------------------------- --- > Asif > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php