PHP Apache and MSSQL

krayz

Hi,

I have just tried PHP with MS SQL. I am able to connect to DB, says "db selected"...see the code below.

But it says "query not successful". I don't know why? Any help?
The table name is correct.

-Krayz

$database = "TCB";
$user = "user";
$pass = "passwd";
$hostname = "localhost";

$connection = mssql_pconnect($hostname, $user, $pass) or die (" Unable to connect to the database");

if(mssql_select_db($database, $connection))
echo "db selected";
else
echo "db not selected";

$query= "SELECT * from MASTER_TABLE";

if(mssql_query($query)) //the error is here
echo "query successful";
else
echo "query not successful";

__greg

do you mean MYSQL? not MSSQL?

try changing all that 'mssql' stuff to 'mysql' and make sure that the table 'MASTER_TABLE' actually exists.

TheIceman5

Originally posted by __greg
do you mean MYSQL? not MSSQL?

try changing all that 'mssql' stuff to 'mysql' and make sure that the table 'MASTER_TABLE' actually exists.

he saying MS SQL, meaning Microsoft SQL Server i gather, NOT MySQL, different things. Also he said the table is correct.
other than that i dunno nuthin about MS SQL, its an MS product, its crap. use apache and MySQL, also a tip, use "{" and "}" in your scripts with if statements and loops, it makes it far easier to debug when you start using bigger and better scripts.