Re: mssql_query not returning

Lado.Leskovec@xxxxxxxxx wrote:
HI!

I have been using MySQL in connection with PHP for fun for several
years now, but at work they recently wanted me to develop an
application, that uses MS SQL server 2005.

I managed to overcome several problems and can now connect to server
and to database, but the mssql_query isnt returning anything.

Code I use:
************************************************************************
$connection= mssql_connect($server, $username, $password)
or die("Couldn't connect to SQL Server on $server");

//select a database to work with
$DB = mssql_select_db($database, $connection)
or die("Couldn't open database $database");

$result=mssql_query("SELECT * FROM Persons")
or die("Couldn't create a result.");

mssql_close($connection);

$num_user=mssql_num_rows($result);

$i=$num_user;

while ($i > 0)
{
$Name=mssql_result($result,$i-1,"Name");
echo "$Name<br>";
$i--;
}
************************************************************************

I tried this SQL query from MS SQL Server Management Studio and it
works fine. I get my desired result there. I also tried to supply the
$connection after the SQL statement.

I also tried to remove the "or die("Couldn't create a result.");"
part, which continues the program, but the $result is empty.

What am I doing wrong?

Thanks in advance!
Lado


Hi Lado,

Simply look up what the errorcode was.

So remove the 'or die' part from

$result=mssql_query("SELECT * FROM Persons")
or die("Couldn't create a result.")

, and inspect the error using mssql_get_last_message()

Good luck.

Regards,
Erwin Moller

PS: I had trouble with mssql too, and switched to odbc connection to mssql, which solved a lot of strange things for me. But maybe I setted up the whole thing bad in the first place.
.

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)