Error msg mysql...please HELP!

Discussion in 'Software' started by Babyhack, Jan 3, 2008.

  1. Babyhack

    Babyhack Private E-2

    Hi! Please help! Im stuck with mysql...Its my firt time dealing with mysql and coding.:confused
    I have to create guestbook my connection works fine! I had to create table in mysql database, I have done that. But when I type in comments on my web site they are not transfering to my data base Im getting error mesage:


    Error
    SQL query:

    `autoid``name``email``comment``date_auto` EXPLAIN SELECT *
    FROM `guestbook`

    MySQL said:

    #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 '`autoid``name``email``comment``date_auto`EXPLAIN SELECT * FROM `guestbook`' at line 1

    Could you help me please? :)
     
  2. Wookie

    Wookie Sergeant Major

    `autoid``name``email``comment``date_auto` EXPLAIN SELECT *
    FROM `guestbook`

    I'm not quite sure what that means but you might want to try just running

    select * from guestbook for the query

    or

    select autoid, name, email, comment, date_auto from guestbook

    assuming those are all valid field names

    can you dump the table description and post it?

    describe <tablename> will do it
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds