I am a complete newbie to PHP so apologies if this is really basic but all the other things relating to this issue have not worked so far.
I have been having major problems connecting to my GoDaddy MSSQL Server 2005 Database.
Whenever I use the function MSSQL_Connect I get a function does not exist - I contacted GoDaddy technical support as my instinct is there is an issue possibly with the php.ini file (having read other articles on the internet) but they said that I should be connecting via ADODB using the following:
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("Provider=SQLOLEDB; Data Source='GoDaddyConnectionString';Initial Catalog='GoDaddyDatabase'; User ID='UserID'; Password='Password'");
$rs = $conn->Execute("Select * from entity");
$arr = $rs->GetArray();
$rs = null;
$conn = null;
The result that I get on my webpage is
Fatal error: Call to undefined method variant::GetArray() in D:\Hosting\9256052\html\telephonenumber.php on line 7
What I am trying to achieve is for the results of the database query to be output into an array for later use.
If someone could help here it would be greatly appreciated.