Problem Querying SQL table from PHP

20 pts.
Tags:
PHP
SQL 2008
SQL Server 2008
SQL tables
I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working on, he can run a query against any other table in the database, but not against the new table. I have verified that the user login account he is using has the requisite permissions. I can log in to SSMS with those credentials and runs a select * from the table in question, and it returns all the rows. I can run an osql statement from my desktop and from the developers desktop utilizing the same credentials, and return the rows. I've run a Profiler trace, and watched while he queries other tables and when he queries the new table. When he queries the "customer" table, which has 161 records in it, I see 485 Reads. When he queries the new table "esb_rt", there are 0 reads. I think this is a PHP issue. The developer thinks it's a SQL issue. Can anyone provide any ideas where to look that I'm not looking?

Software/Hardware used:
SQL 2008
ASKED: June 17, 2011  2:50 PM
UPDATED: June 20, 2011  1:16 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Well, we resolved the issue.

Two of the columns were nvarchar(max) due to SQL DBA’s extreme laziness (that’s me). Once I throttled that down to a ‘mere’ 500 each, it worked.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following