Query runs fine on Console but not in PHP
| From: | vish.kohli | Date: | Sun, 17 Aug 2003 20:56:39 +0000 |
| Subject: | Query runs fine on Console but not in PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29928@lists.php.net to get a copy of this message | ||
Hi,
I am trying to execute a stored procedure in PHP via mssql_query ()
function. I pass 8 parameters to it.
The query runs fine in SQL Query Analyzer but when I run it thru PHP, it
behaves strangely. I can get number of rows (mssql_num_rows()) and number of
fields (mssql_num_fields()) in PHP, but when I try to execute
mssql_fetch_object() or mssql_fetch_array() on the same result identifier, I
get a "Page could not be displayed" (standard internet error page).
Please help.
Thanks in advance.