'mssql_query' stucks my script

[don-joy]

HELP!!!
MSSQL2000 ,windows 2000, IIS, php4+.

We have a problem running a quary with mssql.

I try this:
echo "Connect:".($c =
mssql_connect('SERVER','sa',''))."";
echo
"selectDB:".mssql_select_DB('EMS_Config',$c)."";
flush();
$rs = mssql_query('SELECT * FROM [Tester_Table];',$c) or die("query
fails");

echo "query rs:".$rs."";

The mssql_connect succeeds and return a resource ID (#1).
The mssql_select_db succeed too.
(I can see it because of the flush )
But when the code gets to mssql_query, the page is stuck. It is waiting
for the SQL to reply.

The table is leagal, and there are only 3 records in it.
If I give an sql sintax error or a bad table name, I get an immediate
respond from the SQL server, with the correct error message.
When I give a leagal select - it gets stuck, and the php engin even does
not terminate execution, even when the page exceeds the time-limit for
execution of a script-page.

Any ideas?

[don-joy]

Other forum sujest it's the semicolon in the end of the select.
It's not it, I tried also without it

[sarahk]

change your script to

$sql = 'SELECT * FROM [Tester_Table];';
echo $sql . "<br>";
$rs = mssql_query($sql,$c) or die("query
fails");

then copy the query from the browser to mysql and see if it runs. there might be a small error in your syntax.

In the long term you might want to consider picking up one of the db classes which are available to manage your database queries (or write your own). These simplify your code.

[don-joy]

The query is legal.
The mssql query analizer runs it without problems.

Any other ideas?