Dynamic Table - User Controlled

[Cgrady70]

Hi there,

It has been very difficult for me to get started on this problem. I would be very grateful of any help or pointers.

I would like to create a dynamic table (in Dreamweaver) in which a drop down menu allows users to select which columns are displayed from a MySQL database. Certain columns would be displayed by default. It would be a simple case of checking or unchecking boxes on the drop down. The screen would then refresh and show the new information.

Any help would be very gratefully received.

[pixelpusher7]

Well, Dreamweaver won't do anything like that on it's own, so you're going to have to write a lot of programming. Are you using a dynamic language like PHP or ASP? or are you trying to do this through JavaScript or AJAX?

[Cgrady70]

I was hoping to use PHP but the more I look into it the more it seems a Java applet (which I know little about) is the answer. Just to clarify what I'm trying to do: This is a big project that would allow teachers in a school to be able to write reports, fill in tracking information, etc, about students. The biggest challenge is the admin side: Making it easy to change which tracking information is required, etc. I'd be interested to know if you think it might be possible to do something like that using PHP.