Data submission problem

Are the two fields that have Pr limited to two characters? You could increase the field width and have them submit again to see what's being truncated. That may lead you to a solution.

Both fields are varchar.  lesson is 2 two characters long and question is four.

Sorry, I have more questions than answers.

Are those two values ALWAYS "Pr" from that one location?

At what point are you determining the values to be "Pr"? Is that what's being recorded in the database? Do you have any validation or manipulation of the data before it goes into the database? Do you know whether the form is being submitted with those values or if it gets changed somehow before it's recorded in the database?

Is the form field where the raw data is entered on the client side limited to two and four characters, too?

thanks for your response.

To your questions

At what point are you determining the values to be "Pr"? Is that what's being recorded in the database?  Yes these are the values recorded in the database.

Are those two values ALWAYS "Pr" from that one location?
The problem has only occurred for users accessing the site from this one locate.  But not every record submitted is affected. Looks one or the other field is effected but not both at the same time:  Here's examples of 3 records from one user:

The data recorded is: Id, user_name, lesson, question, score, timestamp.  

Normally the data looks like: The lesson and question fields are effected only.

1231, jdoe, 01, q1, 1, 2012-04-21 14:16:09
1232, jdoe, Pr, q1, 1, 2012-04-21 14:17:09
1233, jdoe, 01, Pr, 1, 2012-04-21 14:16:09

Do you have any validation or manipulation of the data before it goes into the database? Do you know whether the form is being submitted with those values or if it gets changed somehow before it's recorded in the database?

The forms are Flash and are just some radio buttons and a submit button. Actionscript is posting to the php file that inserts into the database. The thing is I haven't been able to replicate.  We had issues from some users regarding Flash and their browser configs.  I'm inclined to think that something is going wrong on the particular forms for these users.

It is curious why "Pr" is being recorded. I was thinking it might have some significance in MySQL..  but I guess not.  We have other forms that are working seamless for these same users.  I think I need to look at the actionscript for the forms in question.

Thanks

Thanks,

I think you are correct... I'll take a look at what the is being posted by the client and see if there is anything that might produce "Pr" for certain users.

Thanks for the help!!!