Above is a mockup of the type of thing I'd like to produce. It's a wysiwyg table /datagrid generation application which needs to have the following functions:
I'm fairly proficient using PHP/MySQL and I could probably do something static which requires page refreshes to generate the table but I'd like something a bit more intuitive and instant.
- add/remove table columns
- add/remove table rows (content)
- the ability to sort pre-defined columns
- the ability to save multiple tables in a MySQL database
- the ability to print the table without any editing icons/rows visible
Hopefully the image is pretty self explanatory but to explain;
The red + signs are click able and will add a column to that point when clicked. This will then display (unhide) a box underneath prompting the user to enter a column heading and the option to make it sortable.
The green row at the bottom will add another blank row when clicked (or it could contain the word "empty" or something so that there is something to edit) to the datagrid. This function could just be a button below the datagrid rather than an actual table row.
I'm not sure of the best way of storing this information in MySQL. There are likely to be many tables, but I'll refer to the appropriate forum for this information.
Thanks so much for any assistance you can provide,
Thanks for the reply myst59 but I don't think that's really what I'm after...the example you supplied seems to be pretty static (requires page refreshes) and not AJAX/DHTML.
I've been thinking about ways of doing this and although it's tabular in form, it'll probably be easier to do this with DIVs. Still pretty stuck with this one tho, haven't been able to find anything else with the functions I require.