I have MsSQL running on a php file, for some weird reason I just cant seem to connect to the table called Properties, though using exactly the same code I can connect to any other table in the database. Please help!
Code: Select all
mssql_connect($host_featured_property, $username_featured_property, $password_featured_property);
mssql_select_db($db1);
$result1 = mssql_query("SELECT * FROM Properties"); <-- code breaks here
while ( $record1 = mssql_fetch_array($result1) )
{
$featured_property = $record1["PropertyID"];
echo $featured_property;
}