Professional Web Applications Themes

mysterious syntax error - PHP Development

query failed:1064: 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 'desc) values('9','24','testing')' at line 1 INSERT INTO logins(accountid,userid,desc) values('9','24','testing') I don't see the error. what's going on ?...

  1. #1

    Default mysterious syntax error

    query failed:1064: 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 'desc) values('9','24','testing')' at line 1

    INSERT INTO logins(accountid,userid,desc) values('9','24','testing')

    I don't see the error. what's going on ?
    meltedown Guest

  2. #2

    Default Re: mysterious syntax error

    meltedown wrote: 

    DESC is a MySQL keyword. Try escaping it with tick-marks, i.e. `desc`

    One other thing, integers shouldn't be escaped with quotes. So the whole query
    should be:

    INSERT INTO logins(accountid, userid, `desc`) values(9, 24, 'testing')

    However, if I were you I'd choose a different name for your desc field, because
    it's only going to get confusing or cause hidden errors later down the line.

    --
    Oli
    Oli Guest

  3. #3

    Default Re: mysterious syntax error

    Oli Filth wrote: 
    >
    >
    > DESC is a MySQL keyword. Try escaping it with tick-marks, i.e. `desc`
    >
    > One other thing, integers shouldn't be escaped with quotes. So the whole
    > query should be:
    >
    > INSERT INTO logins(accountid, userid, `desc`) values(9, 24, 'testing')
    >
    > However, if I were you I'd choose a different name for your desc field,
    > because it's only going to get confusing or cause hidden errors later
    > down the line.
    >[/ref]
    Ha Ha !

    I orinally had a field 'in' that didn't work so I tried 'desc'. I guess
    'in' is a keyword too.k Thanks, it works. I'll just change the field names.
    meltedown Guest

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Syntax error
    By middletree in forum Macromedia ColdFusion
    Replies: 11
    Last Post: May 2nd, 03:10 AM
  3. Replies: 13
    Last Post: January 4th, 02:37 PM
  4. error : syntax error at or near $1 for over select rows
    By vinita bansal in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: December 27th, 06:51 PM
  5. Mysterious Error on DELETE
    By Evan Smith in forum IBM DB2
    Replies: 6
    Last Post: September 16th, 11:06 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139