note 2036 deleted from function.mssql-connect by didou
| From: | didou@php.net | Date: | Wed, 21 May 2003 16:05:28 +0000 |
| Subject: | note 2036 deleted from function.mssql-connect by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-48750@lists.php.net to get a copy of this message | ||
Note Submitter: myconid@sover.net
----
<?
$hostname = "localhost";
$username = "login";
$password = "password";
$dbName = "database";
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");
$query = "SELECT * FROM users";
$result = MSSQL_QUERY($query);
$number = MSSQL_NUM_ROWS($result);
$i=0;
if ($number == 0) :
print "No data?";
elseif ($number > 0) :
print "Data:<br>";
while ($i < $number) :
$name = mssql_result($result,$i,"Name");
print $name;
print "<br>";
$i++;
endwhile;
endif;
?>
It works.. if you don't like it, sue me <g>