[RESOLVED] Refreshing tables from mySQL?

[shure2]

Hi,

I am designing a web page and want to have a table which retrieves data from a mySQL database. I have done this before a while ago so this should be ok for me.

I wanted to know if parts of the page can be refreshed (manually or automatically) in php, such as a table with values that I have just added.

Essentially I would be adding data to a mySQL database on the page and then viewing it straight away on the same page in the form of a table.

If this is possible then please give me some guidelines how this can be done or point me in the right direction.

Thanks in advance!

[laserlight]

Search the Web for "AJAX" or "PHP AJAX".

[sandthipe]

AJAX is a more elegant solution, but a quicker solution would be to have the form handler (the script that inserts the info to your D😎 redirect back to the data page. that would refresh the data on the page. this is how most sites do it that don't want to bother with AJAX. you could also add a # link to a certain portion on your page if you wanted the refresh to take the user back to the same part of the page.

if you want to avoid the entire page refresh, AJAX is your route of choice