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
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