Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

error

Archer282Archer282 Member Posts: 243
this is really getting on my nerves

You have an error in your SQL syntax near 'desc) VALUES('','1','title','author','php','4','level','/tutorials/vb','img','20' at line 1


the query is:

INSERT INTO tutorials (id,rates,title,author,cat,rating,level,src,img,date,desc) VALUES('','1','title','author','php','4','level','/tutorials/vb','img','2005-12-11','description')

Comments

  • daviestrachandaviestrachan Member Posts: 26
    Hi
    desc is a reserved word in MySQL
    ie SELECT a, COUNT(b) FROM test_table GROUP BY a DESC

    change field name to description
    Regards Davie


    : this is really getting on my nerves
    :
    : You have an error in your SQL syntax near 'desc) VALUES('','1','title','author','php','4','level','/tutorials/vb','img','20' at line 1
    :
    :
    : the query is:
    :
    : INSERT INTO tutorials (id,rates,title,author,cat,rating,level,src,img,date,desc) VALUES('','1','title','author','php','4','level','/tutorials/vb','img','2005-12-11','description')
    :

Sign In or Register to comment.