[Mickie D]

ok i managed to get the queries out from the php .. silly me lol

here they are if any one else needs them and cant get the jukeboxquerie.php script to work

CREATE TABLE jukebox (
songsid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
sname varchar(255) NOT NULL,
surl varchar(255) NOT NULL,
splay varchar(5) NOT NULL,
PRIMARY KEY (songsid)
)


CREATE TABLE jukeboxadmin (
event smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
playtype smallint(5) DEFAULT '0',
defultsong varchar(255) NOT NULL,
defultdetail varchar(255) NOT NULL,
defultaudio smallint(5) DEFAULT '0',
storehack smallint(5) DEFAULT '0',
PRIMARY KEY (event)
)


INSERT INTO jukeboxadmin VALUES (NULL,'2', 'http://www.xxxx.xxx/midi/midi/xxxx.xxx', 'Description', '1', '0')


right that lot should sort you out ok