I believe I see the problem here is a sample table dump of mine:
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: 209.xx.xxx.xx
-- Generation Time: Apr 22, 2005 at 12:33 PM
-- Server version: 4.0.23
-- PHP Version: 4.3.10
--
-- Database: `xxxxxxxx_xoops`
--
-- --------------------------------------------------------
--
-- Table structure for table `xxxxps_shortcuts`
--
DROP TABLE IF EXISTS `xxxxps_shortcuts`;
CREATE TABLE `xxxxxps_shortcuts` (
`shortcutid` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`hits` int(8) unsigned NOT NULL default '0',
`rating` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`shortcutid`),
KEY `uid` (`uid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
--
-- Dumping data for table `xxxxps_shortcuts`
--
INSERT INTO `xxxxps_shortcuts` VALUES (2, 1, 1105559467, 'Site Statistics Referer', '/modules/statistics/referdetail.php', 381, 0);
INSERT INTO `xxxxps_shortcuts` VALUES (3, 47, 1108942374, 'fgfdfds', '/modules/xhld1/', 0, 10);
INSERT INTO `xxxxps_shortcuts` VALUES (4, 2, 1109216043, 'Discussion Board', '/modules/newbb/', 1, 0);
INSERT INTO `xxxxps_shortcuts` VALUES (5, 199, 1112886087, ': Technology : Security : and', '/search.php', 0, 0);
Notice the difference in this one to yours? In this one notice the single quotes, in your example no single quotes exist. Ignore the ADD DROP Table is exist, that is just if the table exist already and I want to replace the info in the existing table.
Check with the single quotes as above and see if you still get errors.
