05.06.2015, 06:21
Also, don't update EVERY column everytime.
Does the money update everytime you save the data? Nope.
Does the admin-level change everytime? Also nope.
Does the registered value change everytime? Nope.
Only update whatever needs to be updated.
If you change one value, why update 50 variables in your table, overwriting everything that hasn't been changed?
It's like rewriting an entire piece of paper when you only need to fix a typo.
In normal circumstances, you would only erase the faulty character and rewrite only that character, not the entire page, would you?
Using files, you don't have much choice, you need to rewrite the entire file.
But using a database, you only need to update what has changed, not everything at once.
And the biggest mistake you've made:
You format a query but you only send the last one using the mysql_tquery command.
You're not sending all others, you just format them, then overwrite them on the next line.
Does the money update everytime you save the data? Nope.
Does the admin-level change everytime? Also nope.
Does the registered value change everytime? Nope.
Only update whatever needs to be updated.
If you change one value, why update 50 variables in your table, overwriting everything that hasn't been changed?
It's like rewriting an entire piece of paper when you only need to fix a typo.
In normal circumstances, you would only erase the faulty character and rewrite only that character, not the entire page, would you?
Using files, you don't have much choice, you need to rewrite the entire file.
But using a database, you only need to update what has changed, not everything at once.
And the biggest mistake you've made:
You format a query but you only send the last one using the mysql_tquery command.
You're not sending all others, you just format them, then overwrite them on the next line.