PHP MYSQL Deployment Issues

[SeanHarding]

Hi guys n gals.

 

This is my first post on a forum (ever!), im doing this because I cant find any information related to my problem so I hope you guys can help.

 

I have developed a website from scratch using numerous books on php and mysql.

 

The website requires people to create accounts and then login to view our content, i also upload their image during the form.

 

The problem is, some people create accounts with no problems but others try applying multiple times to no avail.

My script checks that all the information has been entered correctly (no empty columns or mysql injection attempts) uploads the image to my server and then inserts the information into a mysql database. So I have numerous images but no mysql accounts. (I know its not the best way to do things but it works for me!)

 

Working in Wales I have people applying from London applying with no problems but at the same time im having local people having problems with inserting the data into mysql.

 

Working with IIS6, MySQL5 and PHP5.

 

Any information relating to my problems will be greatly appreciated.

[fenway]

Are you capturing errors?  Obviously, this isn't a transaction.

[SeanHarding]

Are you capturing errors?  Obviously, this isn't a transaction.

 

No basicaly im assuming that if it works for one person it will work for all.

 

I currently have about 20 users and only 4 have had a problem so far.

 

Each time I use it, there are no problems.

[fenway]

Well, that's 20% failure!  You need to log, at the very least, the queries going to the DB (which mysql can do for you), as well as some debugging info on the php side.