hide some columns

MBK

Hi all,
I have a mysql query and result statement, which then displays the results in a table. What I would like to do now is give the user the option of hiding some of the columns in the table.

i.e.
Heading 1 data1 data2
Heading2 data3 data4
Heading3 data5 data6 etc,etc

I would like to give the user an option at the side of heading two which allows them to hide the field.

Can this be done, if so how?!

Thanks

PHPdev

Sure anything is possible...

So how are you going to have them turn off the coums? Form, or HTML Link?

Either way you are probably looking to dynamicly create your SQL statement, to only select those colums which the user wants to view. This can be done as simply as

$sql = "select ";

if showX {
$sql .= " first_name";
}
.
.
.

As for the table headers, well all you have to do there, is to echo those headers for the colums you want to show, and nothing for the ones you dont...

Hope this helps...

PHPdev