My Sql Help.......... (please Help Me)

**rukiya** · 20.03.08, 15:37

Hi Friends,

I am trying to use the following script.

I downloaded it from this forum.

I upload all the files also cofiguring the config.php file. but when i insert tables i get following ERROR!!
=============================

SQL query:

--
-- Table structure for table `landofwap_toplist`
--
CREATE TABLE `landofwap_toplist` (
`id` int( 4 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 30 ) NOT NULL default '',
`pass` varchar( 30 ) NOT NULL default '',
`mail` varchar( 100 ) NOT NULL default '',
`link` varchar( 150 ) NOT NULL default '',
`logo` varchar( 150 ) default NULL ,
`cat` varchar( 20 ) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`lastout` datetime NOT NULL default '0000-00-00 00:00:00',
`lastin` datetime NOT NULL default '0000-00-00 00:00:00',
`incoming` int( 10 ) NOT NULL default '0',
`out` int( 10 ) NOT NULL default '0',
`total` int( 10 ) NOT NULL default '0',
`description` varchar( 150 ) NOT NULL default '',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` )
) TYPE = MYISAM AUTO_INCREMENT =22;# MySQL returned an empty result set (i.e. zero rows).
--
-- Clock for counter reset `landofwap_clock`
--
CREATE TABLE `landofwap_clock` (
`time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `time` ) ,
UNIQUE KEY `name` ( `time` )
) TYPE = MYISAM AUTO_INCREMENT =22;# MySQL returned an empty result set (i.e. zero rows).
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 ';# MySQL returned an empty result set (i.e. zero rows).

--
-- Clock for co' at line 22
==========================================
i am using free hosting from http://micklemuckle.0lx.net also this is my first time i am working with php and my sql database so please help me please..................[/b]

Code:

-- 
-- Table structure for table `landofwap_toplist`
-- 
CREATE TABLE `landofwap_toplist` (
`id` int( 4 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 30 ) NOT NULL default &#39;&#39;,
`pass` varchar( 30 ) NOT NULL default &#39;&#39;,
`mail` varchar( 100 ) NOT NULL default &#39;&#39;,
`link` varchar( 150 ) NOT NULL default &#39;&#39;,
`logo` varchar( 150 ) default NULL ,
`cat` varchar( 20 ) NOT NULL default &#39;&#39;,
`date` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
`lastout` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
`lastin` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
`incoming` int( 10 ) NOT NULL default &#39;0&#39;,
`out` int( 10 ) NOT NULL default &#39;0&#39;,
`total` int( 10 ) NOT NULL default &#39;0&#39;,
`description` varchar( 150 ) NOT NULL default &#39;&#39;,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` ) 
) TYPE = MyISAM AUTO_INCREMENT =1;

-- Clock for counter reset `landofwap_clock`
-- 
CREATE TABLE `landofwap_clock` (
`time` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
`name` varchar( 30 ) NOT NULL default &#39;&#39;,
PRIMARY KEY ( `time` ) ,
UNIQUE KEY `name` ( `name` ) 
) TYPE =MyISAM;

use it

**trogenhorse** · 20.03.08, 16:56

Script is still not running well...........

**rukiya** · 20.03.08, 17:13

try http://6te.net host because your host is freehost from byethost.com that does not allow now wml script in free accounts

**trogenhorse** · 21.03.08, 05:04

Thanks A lot................... thanks for helping me.................

one question i have in my mind is that will i have to upload all the files in the Root folder (MAIN PATH like www.......com/ROOT FOLDER), Can i upload files by creating a folder on the ROOT (LIKE www. ...... . com/Rootfolder/ toplist).

Will i have to make changes to database or config.php file.......... help me.... ONCE AGAIN..........

**roger** · 24.03.08, 15:58

yea u will hav to do ur config over and u can do toplist.yourdomain.watever

**trogenhorse** · 25.03.08, 18:14

thanks roger

My Sql Help.......... (please Help Me)

My Sql Help.......... (please Help Me)

Comment

Comment

Comment

Comment

Comment

Comment