Help with this shout box script or sugest a new one

Discussion in 'PHP' started by ScottDB, Jun 15, 2011.

  1. #1
    Hi all, I am trying to add a realy simple free shout box script to my site. I got the script form a post here. http://forums.digitalpoint.com/showthread.php?t=686519 . I know some php and sql and have been trying to get the sql to work for this. Any help would be appreciated. If you know of a realy good schout box script that is very basic and small let me know please.

    The problem I am having is inserting the code into the database. Here is what I have been trying for the example from the linked post above.

    CREATE TABLE shouts (
    id int(11) NOT NULL auto_increment, 
    name varchar(30),
    shout varchar(130),
    contact varchar(130)
    PRIMARY KEY(`id`)
    );
    Code (markup):
    I keep getting the error message: #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 '(`id`) )' at line 6

    Thanks for any suport
     
    ScottDB, Jun 15, 2011 IP
  2. fmjames

    fmjames Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    CREATE TABLE shouts (
    id int(11) NOT NULL auto_increment, 
    name varchar(30),
    shout varchar(130),
    contact varchar(130),
    PRIMARY KEY(`id`)
    );
    PHP:
    You forgot the ","
     
    fmjames, Jun 15, 2011 IP
  3. ScottDB

    ScottDB Greenhorn

    Messages:
    95
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    Hey thanks, That did it. I cant believe I didn't see that the last 15 times I looked at it. lol
     
    ScottDB, Jun 15, 2011 IP