[PHP] Maintenance Panel Tutorial

[Independent]

Whats wrong with that

I was just stating rofl.

[Amiten]

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

Error
SQL query: 

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 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

[Independent]

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

Error
SQL query: 

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 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:

 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 

[Calon]

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

[Turbocom]

Warning: Cannot modify header information - headers already sent by (output started at /home/vivhost/public_html/maintenance/config.php:13) in /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:13) in /home/vivhost/public_html/maintenance/login.php on line 17 

[-leestrong-]

Nice and simple.
Well done!

- Lee