create custom database table?

hye there,
i have successfully create database for my playlist song and emailed it using custom CSS template.
BUT
the record in database that i've created showed in vertical and inside phpmyadmin it showed in horinzontal table which are un-arrangeable.

can u please assist me on how can i save in database with custom table? So when im export it to excel, its look arrangeable.

Hi mat_rapit,

I'm sorry I don't understand your question. The way the inputs are shown in horizontal rows in the create table has nothing much to do with how the table will export to a CSV file.

Bob

Hye,
Sorry for the misunderstanding.
I hope this image will help:


I've seen the CSV Export [GH] and i think it can be done using the 'Columns details' action but
i don't know how to start.
FYI: the Song and Singer fields are about 40 and i've make it as song1,singer1,song2,singer2 and so on.
I need it to be like that since the client want to see it in orderly fashioned.
I hope you will help me.
Thanks!

Hi mat_rapit,

I'm afraid that you get to write the export code by hand :-( No exporter that I have seen will handle that kind of formatting.

Bob

PS I also suggest that you look at refactoring your table design so that the 'track' info is in a separate table from the 'album' info with one track per record. This will make your coding quite a bit simpler.

Thanks for the idea, i have re-build my database table manually and now everything looks fine.

Hye Mark
Sorry for late reply....my problem are solved when i re-build the database table manually.
Thanks again!