I am having an issue returning the array.
This is part of my connection class.
public function CreateDataSet($IncomingSql) {
$this->stmt = sqlsrv_query($this->conn, $IncomingSql);
if ($this->stmt) {
$this->Rows = sqlsrv_has_rows($this->stmt);
if ($this->Rows) {
while($this->Row = sqlsrv_fetch_array($this->stmt, SQLSRV_FETCH_NUMERIC))
{
$this->MyArray[] = $this->Row;
}
}
return $this->MyArray;
//$this->Result = $this->Row;
//return $this->Result;
}
}
And this is how I am calling it on my page...
$conn3 = new ConnectionClass;
$MyDataSet = $conn3->CreateDataSet('Select top (100) city, state, postalcode from store');
echo $MyDataSet[0];
I am using the echo just as a test.
The $MYDataSet is echoing nothing. I can see the $MyArray fill up with all 100 records when I debug, but it does not return it..