Mysql query produces different results for different users
Date: December 05, 2012 07:02PM
On my website I have a form with 6 fields the user fills in order to retrieve desired records from database.
The user can leave all fields empty, in which case all the records are displayed.
Alternetively, he can fill any combination of fields and the mysql query will be built dynamically based on the user's choices.
When I click the submit button, it works fine, no matter what fields combination I fill in the form.
But, I have a problem with a user, actually a company with a network of 20 users connecting online using Sbox (router).
When they leave all the above form fields empty, they get the recordset and it's working fine. But, when they fill any of the form fields (any number of fields in any combination), they get an empty recordset. No errors but no records.
I have no idea what's the reason for this.
If they get all the records when the form fields left empty, it means they connect successfully to the database. Also, the PHP code is OK, after all I tested it and it worked (and still working) fine.
So if there is no connection problem and no code problem, what can the problem be?
If it is relevant, the difference between their computers and mine:
They use ie8 (I use ie9)
Their OS: Windows XP (mine Windows 7)
Om all stations they have NOD32 antivirus. (I have a different one)
I don't think any of the above is relevant, but because the situation is so
unexpected so I don't know where to look for the solution, I provide all details....
Thanks for your help!