Is PHP a screwed up language?

[cafeenman]

I'm finding that my PHP code will randomly stop working in places. I'm not kidding. I'm talking about files that I haven't touched that worked an hour ago, don't work now.

Latest... my guest book wouldn't add the EMail field value to the database. I checked the files and sure enough, the e-mail was being passed, but it wouldn't update in the database.

So I went through every related file and made sure the field was in the same case as it is in the database. It was.

So I removed the 'E' from EMail in the database and every field and now it works. Nothing else was changed. I didn't add or remove any other characters at all. Just removed the E.

This happened the other day with the UserName field. I deleted the field from the database and added it back and it worked fine. used the same case and set up the field exactly as it was before.

Maybe it's not PHP, but mySQL. I guess it could be my host as well, but I don't see how.

Anyone have any ideas about this? Again, every single element in all my code was as it should have been, so it wasn't a mis-named field or something like that. EMail is only in 3 places.

The textbox name and twice in the INSERT INTO statement. That's it.

[The Hobo]

I've noticed this before as well. I'd add a snippet to my database, and it would be on my main page as "What's new?" but it wouldn't be in the database. So I'm pretty sure it's MySQL not PHP causing the problems. As how to fix it or what causes it, your guess is as good as mine.

[chrisjk]

I've never noticed this and I would doubt mysql is to blame; it can be used in mission critical apps. It wouldn't suffer from silly errors like that.

PHP has had a load of bugs lately; maybe you've discovered a new one. Search their archives to see if anyone has picked up on it http://bugs.php.net/