php sql design populating and manipulating dynamic html tables. What is the best way?

urbananarchist

New member
I want to store sets of information in sql and access it so that I can populate a table with text, links and pictures without having to rely heavily on html. Should be easy enough. I then want to run a php script that runs through the whole database until EOF generating a html table.

After generating the html table I want to be able to apply possibly javascript to make it sortable and filterable without having page reloads. What I want to know before I invest alot of time is: Is it possible to apply javascript to a table that isn't defined fully until all of the information is recieved from the sql server.

What I want to accomplish is an easily navigatable, visually appealing, sortable and filterable database that I can quickly add new information to.

And lastly can I use sql to spit out html formatting along with links etc into one cell of the table, is this good practice or is there a flaw I'm not aware of.
Can you use multiple types of data in a single row of a sql table.
 
Back
Top