Inconsistent updating of the database

darkangel228

Hey all,

First off I am a PHP/MySQL newbie, so please bear with me, but I do have an IQ greater than 5, so I can understand things if I just get an answer.

I run a website that is PHP/MySQL based. I have a database, and a PHP Form that adds/updates to it. Simple right?

The only problem is that I am getting inconsistent results, and what I mean is this:

I will post a news article at one moment, and it will add fine. I will update an article at one moment, and it does fine. But then I can go back like 5 mintues later to update it and it won't, or it wont add a new article.

A friend told me that I may not have been closing the MySQL session. I added that, and it still does it.

Suggestions?

the phps code can be found at:
http://darkangel.homelinux.com/add3.phps

It's just an annyance..I know the fields and everything are correct, but would just like it to be consistent.

thanks!!

ultraslacker

Maybe I'm just a sloppy coder, but I have never seen the use of *_close in php.

Are you caching? Are you refreshing your browser - I'm asking the silly questions because I could not reproduce the problem.

darkangel228

"Are you caching? Are you refreshing your browser - I'm asking the silly questions because I could not reproduce the problem."

I cpuld be. Like Isaid.. you have to try and update a couple of records whithin a few minutes of each other.

Someone told me that this php code was designed for php 3. I have php 4...

so th referrals to $id should actaully $_POST["id"] and so for for the rest of the variables....

Does this sound correct?

ultraslacker

so th referrals to $id should actaully $_POST["id"] and so for for the rest of the variables....

If register_global vars is off in your php.ini.

darkangel228

no my register_global is on.

what difference should this make?

Like I said.. I am a newbie