Results 1 to 3 of 3

Thread: Need Help!

  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Unanswered: Need Help!

    CREATE TABLE `admin_logs` (

    `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `user` int( 11 ) NOT NULL default '0',
    `time` int( 11 ) NOT NULL default '0',
    `ip` varchar( 20 ) NOT NULL default '',
    PRIMARY KEY ( `id` )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =114



    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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=114' at line 25

    Help Please

    "Welcome to phpMyAdmin 2.6.4-pl2
    MySQL 4.0.25-standard running on localhost as idesigns@localhost"

  2. #2
    Join Date
    Feb 2005
    Location
    Oklahoma City, Oklahoma
    Posts
    39
    (I tried to help, I am not fluent enough.)

    But, the code he posted at the start is where the error is.
    PHP Code:
     ENGINE MYISAM DEFAULT CHARSET latin1 AUTO_INCREMENT =114 
    That is line 25, so I had him post the whole statment. Please help him, thanks!

  3. #3
    Join Date
    Nov 2005
    Posts
    2
    i fixed it, thanks anyways

Posting Permissions

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