php Gurus? - Is this happend with anybody

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
coolpravin
Forum Newbie
Posts: 20
Joined: Mon May 19, 2003 12:56 am
Location: India

php Gurus? - Is this happend with anybody

Post by coolpravin »

I am trying to execute a mysql queries in a sequence.
Let me explain. :oops:
In a file i am having some mysql queries ,some select,insert and update.
When there is no load on the server this script executes very well .
But when the number of users access to the site then this sctipt
does the update and select queries randomly.

Code: Select all

e.g when i select balance field from a table
and i want to update it in next statement then it works well for low load on server.
But when load is more then before this update some queries are inserted and the balance is changed
but our select query is having old balance and thus all next calculations are wrong.
Did you got it?
Did anybody faced the same?
is there any solution for this
Post Reply