ID: 26296
Updated by: [email]sniperphp.net[/email]
Reported By: ameen at whitehouseit dot com
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2000 Server
PHP Version: 4.3.4
New Comment:

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions.

Thank you for your interest in PHP.




Previous Comments:
------------------------------------------------------------------------

[2003-11-18 01:48:03] ameen at whitehouseit dot com

Description:
------------
Just i try to connect my database in SQL Server and fetch some records
from the database. But it shows warning message like this.

Warning: mssql_query(): message: Invalid object name 'mytable'.
(severity 16) in D:\abc\Conn.php on line 21

Warning: mssql_query(): Query failed in D:\abc\Conn.php on line 21

How to rectify? i'm sure tables exists in my db. and also connection
establishes perfectly.

Reproduce code:
---------------
$i=mssql_connect("localhost","uid","pwd") or die("unable to
Connect");
if (mssql_select_db("mydb",$i)==true)
echo "DB Exists";
else
echo "DB Not Exists";

$sql="select * from mytable where login_id='myname'";

$rs=mssql_query($sql,$i);

Expected result:
----------------
Warning: mssql_query(): message: Invalid object name 'mytable'.
(severity 16) in D:\abc\Conn.php on line 21

Warning: mssql_query(): Query failed in D:\abc\Conn.php on line 21


Actual result:
--------------
Fetch Records from db


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=26296&edit=1[/url]