refresh mysql to update after running code ?

[ejwf]

Is there a simple line of code that I can put at the end of a command that will tell mysql database to update / refresh the table with the new information straight away?

I have a web based user interface that allows the user to carry out a few functions to update / amend information on the mysql database, however I need the database to refresh straight away so they can use this new information in another query / function.

Is there a simple way of doing this?

TIA

[Andrew_W_Peace]

If I'm not mistaken the database does take changes automatically. If a person is making changes to the database, they should appear right away. Are you having trouble with the database not refreshing correctly, or were you just wondering? If you are having problems, it might just be with your browser's cache. Try using the header() function like so:

header("Cache-Control: no-cache, must-revalidate");

Hope this helps!