Code:
DAX file:
================
=====Start Page====
CREATE TABLE if not exists music_albums
(
id int(5),
artist_name varchar(100),
album_name varchar(100),
album_time varchar(10),
format varchar(10),
bitrate varchar(5),
bootleg char(3),
genre varchar(15),
rare char(3),
soundtrack char(3),
rel_year int(4),
live char(3),
comment longtext,
trackcount int(3),
date_added date,
cover varchar(100)
);
TRUNCATE TABLE `music_albums`;
<!--[album(all,artist,title)]-->
insert into music_albums (id, artist_name, album_name, album_time, format, bitrate, bootleg, genre, rare, soundtrack, rel_year, live, comment, trackcount, date_added, cover) VALUES ("", "<!--[artist/]-->", "<!--[title/]-->", "<!--[albumtime/]-->", "<!--[format/]-->", "<!--[bitrate/]-->", "<!--[bootleg/]-->", "<!--[genre/]-->", "<!--[rare/]-->", "<!--[soundtrack/]-->", "<!--[year/]-->", "<!--[live/]-->", "<!--[comment/]-->", "<!--[trackcount/]-->", "<!--[dateadded/]-->","<!--[volume]--><!--[if(cover)]--><!--[cddbid/]-->.jpeg <!--[/if]--><!--[/volume]-->");
<!--[/album]-->
This creates the sql table (music_album) and then adds all of the data to it...the only exception is this cover problem, but theres a nice solution: