rtpmatt Posted June 15, 2007 Share Posted June 15, 2007 hey, I have a particular page that first updates my database, then reads from the database. It seems that my db is using a counter or something, so it wont get the new entries that have just been added. is there a quick way to "reset" my current query so that it will research the entire DB? thanks -matt Quote Link to comment https://forums.phpfreaks.com/topic/55657-solved-getting-database-updates-after-making-them/ Share on other sites More sharing options...
redarrow Posted June 15, 2007 Share Posted June 15, 2007 show ur update query. Quote Link to comment https://forums.phpfreaks.com/topic/55657-solved-getting-database-updates-after-making-them/#findComment-275045 Share on other sites More sharing options...
pocobueno1388 Posted June 15, 2007 Share Posted June 15, 2007 You shouldn't have to reset the query, as it will pull whatever the database has in it, regardless of when it was updated. You probably only need to refresh the page to show the update. You also might want to take a look at order of operations in your script. When you press update, I assume it refreshes the page...but you probably have the update query below the content of the page in the script, try moving it to the top and the updated results will be pulled rather than the old ones without having to refresh. Quote Link to comment https://forums.phpfreaks.com/topic/55657-solved-getting-database-updates-after-making-them/#findComment-275046 Share on other sites More sharing options...
rtpmatt Posted June 15, 2007 Author Share Posted June 15, 2007 not quite sure why, but the problem seems to have gone away. thanks for the help -matt Quote Link to comment https://forums.phpfreaks.com/topic/55657-solved-getting-database-updates-after-making-them/#findComment-275077 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.