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!


Page 4 of 4 FirstFirst 1234
Results 31 to 36 of 36
  1. #31
    Join Date
    Dec 2007
    Posts
    1,683
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Tom743 View Post
    Whats wrong with that
    I was just stating rofl.

  2. #32
    Join Date
    Jun 2007
    Posts
    16
    Tokens
    0

    Default

    umm problem when i enter my sql thing this error comes up :9 im ok with html but cant get hy head around my sql could anyone help? thanks


    PHP Code:
    Error
    SQL query


    CREATE TABLE `sitestatus` (

    `
    idINTNOT NULL AUTO_INCREMENT ,
    `
    statusVARCHAR10 NOT NULL ,
    `
    offmsgTEXT NOT NULL ,
    `
    onpageVARCHAR50 NOT NULL ,
    PRIMARY KEY ( `id` ) 
    ENGINE MYISAM INSERT INTO `sitestatus` ( `id` , `status` , `offmsg` , `onpage` ) 
    VALUES (
    '1''off''The site is currently offline for some much needed maintenance work on the frameworks!''http://example.com/'


    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 'INSERT INTO `sitestatus` (
    `id` ,
    `
    status` ,
    `
    offmsg` ,
    `
    onpage`
    )
    VALUES ' at line 9 
    tom

  3. #33
    Join Date
    Dec 2007
    Posts
    1,683
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Amiten View Post
    umm problem when i enter my sql thing this error comes up :9 im ok with html but cant get hy head around my sql could anyone help? thanks


    PHP Code:
    Error
    SQL query


    CREATE TABLE `sitestatus` (

    `
    idINTNOT NULL AUTO_INCREMENT ,
    `
    statusVARCHAR10 NOT NULL ,
    `
    offmsgTEXT NOT NULL ,
    `
    onpageVARCHAR50 NOT NULL ,
    PRIMARY KEY ( `id` ) 
    ENGINE MYISAM INSERT INTO `sitestatus` ( `id` , `status` , `offmsg` , `onpage` ) 
    VALUES (
    '1''off''The site is currently offline for some much needed maintenance work on the frameworks!''http://example.com/'


    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 'INSERT INTO `sitestatus` (
    `id` ,
    `
    status` ,
    `
    offmsg` ,
    `
    onpage`
    )
    VALUES ' at line 9 
    tom
    I had this problem too;

    Remove the insert bits, and put this only execute this query:
    Code:
     CREATE TABLE `sitestatus` (
    `id` INT( 2 ) NOT NULL AUTO_INCREMENT ,
    `status` VARCHAR( 10 ) NOT NULL ,
    `offmsg` TEXT NOT NULL ,
    `onpage` VARCHAR( 50 ) NOT NULL ,
    PRIMARY KEY ( `id` )
    ) ENGINE = MYISAM 
    

  4. #34
    Join Date
    Jul 2008
    Location
    Hastings, UK.
    Posts
    2,050
    Tokens
    0

    Latest Awards:

    Default

    I was in the middle of writing new code for Ed's system, but I have to go.

  5. #35
    Join Date
    Mar 2008
    Posts
    940
    Tokens
    75

    Default

    PHP Code:
    WarningCannot modify header information headers already sent by (output started at /home/vivhost/public_html/maintenance/config.php:13in /home/vivhost/public_html/maintenance/login.php on line 16

    Warning
    Cannot modify header information headers already sent by (output started at /home/vivhost/public_html/maintenance/config.php:13in /home/vivhost/public_html/maintenance/login.php on line 17 


  6. #36
    Join Date
    Nov 2006
    Location
    Coventry
    Posts
    479
    Tokens
    1,292

    Default

    Nice and simple.
    Well done!

    - Lee
    Student Pilot EGBW | Cessna 152 G-BHPY G-BTVW
    Passed Air Law exam April 25th

Page 4 of 4 FirstFirst 1234

Posting Permissions

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