meghatronic

I have a fairly simple mysql database that has a number of fields.

I have writtens some php to display the data from the database seperated by field. This is okay. (i.e. in a table).

What I'd like to do is have someway of dynamically choosing which fields to output (javascript?).

I.e. Say the database contains fields 1, 2, 3, 4 and 5.

I'd have check boxes under the headings 1-5 and the user can chose what fields to output. I.e. if 1 and 3 ticked only, then only the data from fields 1 and 3 would be outputted.

Second question, at the moment I am displaying the data echod in php to plain text, however I'd like to give the option to 'download' the data as a text file... any ideas?

Cheers guys

O~Snapple

ok this sounds like a fun project....

Well for the first part...

make the check boxes part of a form, and make the action query the database and have it say IF 1 is checked then echo 1 else die or something along those lines.

The second part i would do something similar give the user the option set the form to IF download then (Download Function).

I dont know the exact code off the top of my dome, but this should send you in the right direction.


~Snapple

__________________
The Real Truth
Epademik Emcee Esq. New Album The 3rd Finger is in Stores Now!
Snap Marketing Management and Consulting

meghatronic

Presumuably I'd have to write the information to a temporary file before download, though?