database updates not showing up immediately

Question

hi, i have a php application driven by mysql data. ie. when a user rates on a product .it gets stored in DB and the page gets refreshed. then also his ratings donot get showed up until cache is cleared. i have put the cache control code also .

header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past

any tweaks that i have to do for this?

Answer 1

Try

SELECT SQL_NO_CACHE * FROM table