Is this a correct querri?

[RichieBoy67]

I keep getting a syntax error..

PHP Code:

CREATE TABLE '. TABLE_PREFIX .'vb_jukebox_trax (
`songid` smallint(5) unsigned NOT NULL auto_increment, 
`title` varchar(100) NOT NULL default '\',
`url` varchar(100) NOT NULL default \'\',
`plays` smallint(5) default \'0\',
`active` int(2) NOT NULL default \'0\',
`userid` int(11) NOT NULL default \'0\',
`username` varchar(225) NOT NULL default \'\',
`rated_qty` int(5) NOT NULL default \'0\',
`rating` int(5) NOT NULL default \'0\',
`announce` int(2) NOT NULL default \'0\',
`genre` varchar(50) NOT NULL default \'\',
PRIMARY KEY (`songid`) 


[Paul M]

Well at first glance it looks like a missing \ on the "title" line - after the word "default".

[Zachery]

Originally Posted by RichieBoy67

I keep getting a syntax error..

PHP Code:

CREATE TABLE '. TABLE_PREFIX .'vb_jukebox_trax (
`songid` smallint(5) unsigned NOT NULL auto_increment, 
`title` varchar(100) NOT NULL default '\',
`url` varchar(100) NOT NULL default \'\',
`plays` smallint(5) default \'0\',
`active` int(2) NOT NULL default \'0\',
`userid` int(11) NOT NULL default \'0\',
`username` varchar(225) NOT NULL default \'\',
`rated_qty` int(5) NOT NULL default \'0\',
`rating` int(5) NOT NULL default \'0\',
`announce` int(2) NOT NULL default \'0\',
`genre` varchar(50) NOT NULL default \'\',
PRIMARY KEY (`songid`) 


Well thats not a syntax error, thats a query.

Whats the error, and what are you trying to run it in

[RichieBoy67]

Forget it. I figured it out... Thanks

Sorry, I didn't post the error but it said syntax so I figured that I did something wrong with the query. This is fixed now... now I just need to find out what else is wrong...lol

-

[Paul M]

Well how about telling us what was wrong then .....

[RichieBoy67]

I did it the easy was and added it directly so I didn't need to do query.... MYSQL is not my thing at all...

--