fatal error sqlsvr_fetch_array(). Cannot fetch array from query

Question

This is driving me crazy and I can't seem to find any solutions online. I'm trying to use the sqlsvr_fetch_array() function and keep getting a fatal error. It says: "Fatal error: Call to undefined function sqlsvr_fetch_array() in C:\inetpub\wwwroot\confirmation.php on line 39"

This is my code:

$connectionInfo = array(
"UID" => 'sa',
"PWD" => '*******',
"Database" => "****"
);

/* Connect using SQL Server Authentication. */
$conn = sqlsrv_connect('10.206.244.103', $connectionInfo);
if ($conn === false) {
echo "Unable to connect.</br>";
die(print_r(sqlsrv_errors(), true));
} else {

echo 'CONNECTED';    
}
$params = array();
$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); 
$sql1 ="SELECT * FROM temp_survey_table WHERE Confirm_Code = 'e32c7cdaf237322234f5ac3e768fbaa9'";
$result1 = sqlsrv_query($conn,$sql1, $params, $options);

$rows=sqlsvr_fetch_array($result8);
$invoice=$rows['Invoice_Number'];
$email=$rows['Email'];
$servicerate=$rows['Service_Rate']; 
$foodrate=$rows['Food_Rate'];
$comments=$rows['Comments'];

echo $invoice;
echo $email;
echo $servicerate;

Any help will be greatly appreciated. Thanks in advanced.

Jon · Accepted Answer · 2012-09-29 23:41:04Z

1

Typo: it's sqlsrv_, not sqlsvr_.

            ^ RV        ^ VR

Quite difficult for a human to distinguish indeed.

answered Sep 29, 2012 at 23:41

Jon

439k85 gold badges756 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1594645 Over a year ago

Ahhhhhhhhhhhhhh! That was it! Thanks dude. Don't worry, I slapped myself for you.

Collectives™ on Stack Overflow

fatal error sqlsvr_fetch_array(). Cannot fetch array from query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related