Re: Strange MySQL Problem

You're missing a tick in the query. There should be a tick before the $_POST[ISBN]. Take care, Floyd On Dec 14, 2009, at 3:41 AM, Parham Doustdar wrote: > Hello there, > Here's a short PHP script a friend has written, and given to me to test. > However, I am getting a MySQL error saying that the syntax error, on the > line that contains mysql_connect(); is wrong, near '')' > (note that it is not a PHP error, but a MySQL error.) > Here's the code: > > [code] > <?php > $username = "root"; > $password = "abc"; > $con = mysql_connect("", $username, $password); > mysql_select_db ("test", $con); > $sql = "INSERT INTO BOOK(bookname, authorsname, ISBN) VALUES > ('$_POST[bookname]', '$_POST[authorsname]', $_POST[ISBN]')"; > if (!mysql_query($sql, $con)) > { > die( 'error: ' . mysql_error()); > } > echo "1 record added"; > mysql_close($con) > ?> > [/code] > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php