PHP Forum

**wise1** · 11:50 AM

Hello,

I am quite new to PHP but have managed quite well so far, my problem is with the script below. Can anyone help me?

It generates this message:

Code:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '()' at line 6

From this code:

PHP Code:


			
<html>



<form name="form1" method="post" action="<?=$_SERVER['PHP_SELF']?>">

  <p>Article Name: 

    <input name="heading" type="text" id="heading" size="50">

</p>

  <p>Article Text: 

    <textarea name="article" cols="100" rows="15" id="article"></textarea>

</p>

  <p>Author: 

    <input name="author" type="text" id="author"> 

    Source: 

    <input name="source" type="text" id="source">

</p>

  <p>

    <input type="submit" name="submitnews" value="Submit">

</p>

</form>







<?



// Connecting

$connect = @mysql_connect('localhost', 'root', 'martin');

if (!$connect) {

die( '<p>problem ' . mysql_error() . '</p>');

}



// Select Database

$select = @mysql_select_db('mortgage');

if (!$select) {

die( '<p>problem ' . mysql_error() . '</p>');

}    



if (isset($_POST ['submitnews'])) {

    $heading = $_POST['heading'];

    $article = $_POST['article'];

    $author = $_POST['author'];

    $source = $_POST['source'];



    

$sql = "INSERT INTO news SET

        heading = '$heading',

        article = '$article',

        author = '$author',

        source = '$source',

        articledate = CURRDATE()";

        

if (@mysql_query($sql)) {

    echo('<p>Your article has been submitted</p>');

    } else {

    echo('<p>Houston We have a problem!' . mysql_error() . '</p>');



    }

}



?>

</html>

**Buddha443556** · 12:55 PM

Quote:

From the manual:

The INSERT ... SET syntax is supported in MySQL 3.22.10 or later.

Check the version of MySQL supports the INSERT ... SET syntax.

PS

CURRDATE()? Did you mean CURRENT_DATE, CURRENT_DATE() or CURDATE()?

**wise1** · 03-12-2005, 02:00 PM

Thank You!

It was CURRDATE () causing the problem, as you rightly pointed out it should have been CURDATE()

Thanks

Lee