Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Results 1 to 5 of 5

Thread: SQL Querie

  1. #1
    Join Date
    Sep 2005
    Posts
    1,604
    Tokens
    0

    Latest Awards:

    Default SQL Querie

    Anybody tell me whats rong with this. coz when i put it in PHPmyadmin it says that its wrong.

    HTML Code:
    CREATE TABLE `news` ( 
    `id` int(10) NOT NULL auto_increment, 
    `title` varchar(50) NOT NULL default '', 
    `author` varchar(30) NOT NULL default '', 
    `content` text NOT NULL, 
    `postdate` varchar(25) NOT NULL default '', 
    PRIMARY KEY (`id`) 
    ) TYPE=MyISAM
    
    CREATE TABLE `news_comments` ( 
    `id` int(10) NOT NULL auto_increment, 
    `author` varchar(30) NOT NULL default '', 
    `content` text NOT NULL, 
    `postdate` varchar(125) NOT NULL default '', 
    `nid` varchar(30) NOT NULL default '', 
    PRIMARY KEY (`id`) 
    ) TYPE=MyISAM

  2. #2
    Join Date
    Jun 2006
    Location
    Northamptonshire
    Posts
    1,063
    Tokens
    0

    Latest Awards:

    Default

    Looks to me like 2 differant queries
    :eusa_whis

  3. #3
    Join Date
    Nov 2005
    Location
    Australia
    Posts
    1,086
    Tokens
    111

    Latest Awards:

    Default

    Run this first :

    Code:
    CREATE TABLE `news` ( 
    `id` int(10) NOT NULL auto_increment, 
    `title` varchar(50) NOT NULL default '', 
    `author` varchar(30) NOT NULL default '', 
    `content` text NOT NULL, 
    `postdate` varchar(25) NOT NULL default '', 
    PRIMARY KEY (`id`) 
    ) TYPE=MyISAM
    Than run this :

    Code:
    CREATE TABLE `news_comments` ( `id` int(10) NOT NULL auto_increment, `author` varchar(30) NOT NULL default '', `content` text NOT NULL, `postdate` varchar(125) NOT NULL default '', `nid` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM


  4. #4
    Join Date
    Sep 2005
    Posts
    1,604
    Tokens
    0

    Latest Awards:

    Default

    Oh yeah thanks guys +rep

    Sorry Ryan need to spread rep =]
    Last edited by ClubTime; 22-07-2006 at 11:42 AM.

  5. #5
    Join Date
    Jun 2006
    Location
    Northamptonshire
    Posts
    1,063
    Tokens
    0

    Latest Awards:

    Default

    No probs.
    :eusa_whis

Posting Permissions

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