i have been trying to run the following SQL query however the limit is a keyword and hence i cannot insert it.However i cannot change the field name from limit to something else hence need to get a solution on this.Plz help.......
regards
SQL::
CREATE TABLE code_rotator (
id int(11) NOT NULL auto_increment,
title text NOT NULL,
code text NOT NULL,
weight int(11) NOT NULL default '1',
wcount int(11) NOT NULL default '0',
limit int(11) NOT NULL default '0',
tcount int(11) NOT NULL default '0',
dsub varchar(15) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `code_rotator`
--
INSERT INTO code_rotator (id, title, code, weight, wcount, limit, tcount, dsub) VALUES (3,'abc.com','<script language=\\\'JavaScript\\\' type=\\\'text/javascript\\\'\r\nsrc=\\\'
http://www.abc.com/swarm/links.pl?id=194000&cat=3&num=5\\\'>\r\n</script>',1,1,0,83787,'');