Php output

meghatronic · 15 Oct 2006 at 20:00

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

shine · 15 Oct 2006 at 20:21

You could build your sql statement dynamically i.e.

Code:

$query="SELECT $user_selected_fields FROM table where $fieldname = <some data>";

I have some code that will automatically generate a HTML table from the output of your query. I can't find it right now but'll find it in the morning and post it.

meghatronic · 16 Oct 2006 at 00:35

lol..

I can't believe I didn't think of that.

shine · 16 Oct 2006 at 10:16

No problem

As promised you can find the script for displaying MySQL results in an HTML table here just serach for array2table.

meghatronic · 16 Oct 2006 at 10:20

Cheers.

I'll have a look and a play - any problems I'll post back.

meghatronic · 16 Oct 2006 at 13:26

Right. I've got the script to output based on a prewritten query and am working on making it dynamic now...

However I have the most stupid question. I have the form on one page, how do I make the script output the query results to a new window?