www.webdeveloper.com
Results 1 to 4 of 4

Thread: Basic Insert Syntax Error?

  1. #1
    Join Date
    Feb 2010
    Posts
    9

    Basic Insert Syntax Error?

    I am trying to do just a back insert with some PHP but its throwing a syntax error that i cannot figure out.
    at this point i have connected to my DB successfully.

    Code:
    	if (!$con)
      	{
      		die('Could not connect: ' . mysql_error());
      	}
    
    	mysql_select_db("SeniorP", $con);
    
    	$sql = "INSERT INTO Order (orderID)
    		VALUES ('abcc')";
    	
    	if (!mysql_query($sql,$con))
      	{
      		die('Error: ' . mysql_error());
      	}
    	
    	mysql_close($con);
    The Order table already exists and orderID is a varchar(20). I don't know why its throwing this:
    Code:
    Error: 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 'Order (orderID) VALUES ('abcc')' at line 1
    Thanks

  2. #2
    Join Date
    Sep 2008
    Posts
    33
    You shouldn't have a table (or column) named Order. Rename your table.

  3. #3
    Join Date
    Jul 2010
    Location
    /ramdisk/
    Posts
    865
    "order" is a keyword/reserved word. You can not name your table a keyword.
    Here other possible names you might want to give your table but can not.

    ADD ALL ALTER
    ANALYZE AND AS
    ASC ASENSITIVE BEFORE
    BETWEEN BIGINT BINARY
    BLOB BOTH BY
    CALL CASCADE CASE
    CHANGE CHAR CHARACTER
    CHECK COLLATE COLUMN
    CONDITION CONSTRAINT CONTINUE
    CONVERT CREATE CROSS
    CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP
    CURRENT_USER CURSOR DATABASE
    DATABASES DAY_HOUR DAY_MICROSECOND
    DAY_MINUTE DAY_SECOND DEC
    DECIMAL DECLARE DEFAULT
    DELAYED DELETE DESC
    DESCRIBE DETERMINISTIC DISTINCT
    DISTINCTROW DIV DOUBLE
    DROP DUAL EACH
    ELSE ELSEIF ENCLOSED
    ESCAPED EXISTS EXIT
    EXPLAIN FALSE FETCH
    FLOAT FLOAT4 FLOAT8
    FOR FORCE FOREIGN
    FROM FULLTEXT GRANT
    GROUP HAVING HIGH_PRIORITY
    HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND
    IF IGNORE IN
    INDEX INFILE INNER
    INOUT INSENSITIVE INSERT
    INT INT1 INT2
    INT3 INT4 INT8
    INTEGER INTERVAL INTO
    IS ITERATE JOIN
    KEY KEYS KILL
    LEADING LEAVE LEFT
    LIKE LIMIT LINES
    LOAD LOCALTIME LOCALTIMESTAMP
    LOCK LONG LONGBLOB
    LONGTEXT LOOP LOW_PRIORITY
    MATCH MEDIUMBLOB MEDIUMINT
    MEDIUMTEXT MIDDLEINT MINUTE_MICROSECOND
    MINUTE_SECOND MOD MODIFIES
    NATURAL NOT NO_WRITE_TO_BINLOG
    NULL NUMERIC ON
    OPTIMIZE OPTION OPTIONALLY
    OR ORDER OUT
    OUTER OUTFILE PRECISION
    PRIMARY PROCEDURE PURGE
    READ READS REAL
    REFERENCES REGEXP RELEASE
    RENAME REPEAT REPLACE
    REQUIRE RESTRICT RETURN
    REVOKE RIGHT RLIKE
    SCHEMA SCHEMAS SECOND_MICROSECOND
    SELECT SENSITIVE SEPARATOR
    SET SHOW SMALLINT
    SONAME SPATIAL SPECIFIC
    SQL SQLEXCEPTION SQLSTATE
    SQLWARNING SQL_BIG_RESULT SQL_CALC_FOUND_ROWS
    SQL_SMALL_RESULT SSL STARTING
    STRAIGHT_JOIN TABLE TERMINATED
    THEN TINYBLOB TINYINT
    TINYTEXT TO TRAILING
    TRIGGER TRUE UNDO
    UNION UNIQUE UNLOCK
    UNSIGNED UPDATE USAGE
    USE USING UTC_DATE
    UTC_TIME UTC_TIMESTAMP VALUES
    VARBINARY VARCHAR VARCHARACTER
    VARYING WHEN WHERE
    WHILE WITH WRITE
    XOR YEAR_MONTH ZEROFILL

  4. #4
    Join Date
    Aug 2009
    Posts
    593
    If you haven't already tried, you can put keywords in special `quotes` for your use...

    Code:
    if (!$con)
    {
    	die('Could not connect: ' . mysql_error());
    }
    
    mysql_select_db("SeniorP", $con);
    
    $sql = "INSERT INTO `Order` (orderID) VALUES ('abcc')";
    	
    if (!mysql_query($sql,$con))
    {
    	die('Error: ' . mysql_error());
    }
    	
    mysql_close($con);

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles