PHP Not pulling recordset

[Ambrotos]

Folks,

I have a situation... I am using a MSSQL stored procedure to pull recordsets for a php page. I am naturally using PHP to activate this stored procedure.

However I cannot get to to go through the while loop i am using to pull the info. It doesn't even print the results when i get it to grab just the last row.

Here is a copy of my code...

$PULLINFO=mssql_init("sp_empCreationsearch");
mssql_bind($PULLINFO,"@strYear",&$YEARSELECTED, SQLVARCHAR);
mssql_bind($PULLINFO,"@strMonth",&$MONTHSELECTED, SQLVARCHAR);
mssql_bind($PULLINFO,"@strPein",&$EMPSELECTED, SQLVARCHAR);
mssql_bind($PULLINFO,"@strSystem",&$SYSSELECTED, SQLVARCHAR);
$PULLINFO2 = mssql_execute($PULLINFO);

while($PULLINFO3 = ssql_fetch_row($PULLINFO2)){
$PERSON = $PULLINFO3[1];
$CALLS = $PULLINFO3[2];
echo"$PERSON $CALLS<BR>";
}


any assistance would be greatly appreciated.

Thanks

Angel

 

[sleipnir214]

In your mssql_bind() invocations, I notice you're passing references to all your variables. Are all of these output parameters?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Ambrotos]

Nope... Just parameters I'm passing to it to get the data.

 

[sleipnir214]

In that case, don't pass references, pass the variables. I don't know this will make a difference, but it's something.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Ambrotos]

I've figured it out. What I need to do is set the variables with a value of "" to a value of " " (with a space in it). I don't know why this works but it does. Might have to do with how the stored procedure was written.

Thanks for your help!!

 

[sleipnir214]

As a wild-eyed theory, it may have something to do with NULL-handling between PHP and MSSQL.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Ambrotos]

Maybe your wild eye theory isn't so wild OR eye at all. Cuz when I ran the stored procedure in Query Analyzer it returns the recordset properly.

Just another one of those things that make you go hmmm... (god I hate being a product of the 80s)