simple query
Posted: Thu Apr 01, 2004 5:54 pm
I just need a simple query to see if the mssql works in my php
however it returns Resource id #3
however it returns Resource id #3
Code: Select all
<?
$host = "10.10.10.5:1433";
$usr = "sa";
$pwd = "sa";
$db = "tms";
$connect = @mssql_connect($host, $usr, $pwd)
or die("Couldn't connect to SQL Server on $host");
$select = @mssql_select_db($db, $connect)
or die("Couldn't open database $db");
$query = "SELECT id_mandet01 FROM tms_mandet01";
// id_mandet = field tms_mandet = table
$result = mssql_query($query);
echo $result;
?>