Hello everyone,
my mysql query output in my IE browser is strange from my mysql table. for example, when I querying a varchar type data, i got 6 for null, 4 for 12340877, and all wrong numbers for all records for this column and all other columns are correct.

Anybody can let me know what's wrong with it and how to fix it?

Thank you all all the time,
Jun

Jun,
Check your table and verify how many numbers was setup.
For example, VARCHAR(6) should be VARCHAR(8) to accept 12340877.
Hope this helps.
John M.

Thank you John for your reply and help.
the field is defined as varchar(9) and it returns 9 numbers when i query it in mysql query browser or command line, but just one number in my IE browser,which is not the first number of the correct data. I don't know why it bahaved like this.

Any idea and solution?

Thank you again,
Jun

There is error in your PHP code and/or your MySQL table definition. Since, machine never errors .. We can help you, but we're not having enough explanation/information from your side, to do so.

If you wanna see it yourself, please see your PHP code. You'd been doing something, that changed your output ..

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Students' finances

Thank you John for your reply.
The mistake I made is $ary=array(); ... $ary=something; the correct one should be $ary[]=something. I don't know why php didn't reture any error message but the strange data?

Very appreciate it if you can let me know the reason.

Thank you for you help all the time.
Jun