Discuss Sqlsrv_fetch_array in the PHP Development forum on Dev Shed. Sqlsrv_fetch_array PHP Development forum discussing coding practices, tips on PHP, and other PHP-related topics. PHP is an open source scripting language that has taken the web development industry by storm.
Time spent in forums: 9 h 3 m 35 sec
Reputation Power: 0
This seems like it should be something very simple.
I am running mssql express 2012 on a virtual ms server 2008 r2 machine locally.
I have created a very simple table and query. VERY SIMPLE
the table is designed as above.
I am using a new query now.
SELECT fName, lName, about FROM dbo.person WHERE ID=7
Yes i verified that the ID was 7.
I am connecting to the server via the host machine, Google Chrome and the user is NT AUTHORITY\IUSR. Yes this user has rights to the db.
Connection works, statment works but the fetch_array is returning nothing...
Time spent in forums: 2 Months 3 Weeks 5 Days 10 h 33 m 57 sec
Reputation Power: 6300
Are you SURE the statement works? var_dump everything every step of the way and see if it's all what you expect. Turn error_reporting all the way up and see if there's any warnings that could be giving you clues.