Query lag time...

[Attilitus]

I am trying to store a setting which is dependent upon an entry into the database. I make a change to the database, and then call a function which uses information from the previously changed database setting, and then outputs another setting which I immediately enter into a stored setting spot in the database.

The problem is that for some reason the function once called does not use the updated database entry for its output, but instead it seems that it outputs something before the query finishes updating the relavent field. This "query lag" is causing quite a bit of trouble.

The setup is trying to save around 2 queries per page, so it is pretty important to store this setting in this manner. Is there anyway that I can try and get the function to not output a value until the query finishes updating the relevant field? (I always figured that if the query was above the function, the script would "wait" until it was finished before moving on)

Can anyone give me some insight/advice? Thanks!

[harmor19]

My suggestion is to see if any rows has been affected before proceeding.

PHP Code:


//your query here

if(mysql_affected_rows() == 1)
{
   //your function here
}