easy question

bogdanzagan

<?php
// connect to database server
$db_conn = mssql_connect("10.50.169.98","copsintranet","intranet")
or die( "ERROR: Connection to SPHINX1 failed" );

// select database - only if we want to query another database than the default one
mssql_select_db( "WebCops", $db_conn )
or die( "ERROR: Selecting database failed" );

// query the database
$query_result = mssql_query( "SELECT * FROM trainer", $db_conn )
or die( "ERROR: Query failed" );
?>

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?php echo $query_result; ?>
</body>

Returns

Resource id #2

How can I get the fields ?

The server is MsSql and I use sybase_ct.so loaded in my php module.

Thank You

Anon

$Data=mssql_fetch_array($query_esult);
echo $Data["SomeField"];

You need to get the data from the query resource that's what mssql_fetch_array does. You could use any of the fetch options see (http://www.php.net/manual/en/ref.mssql.php) to find the one that works best for you.

bogdanzagan

Thank you very MUCH !!!!!!
Actually it worked !

I use Linux, Apache, RedHat 7.3, PHP, sybase_ct.so to connect to MsSql server and I can say that combination actually works !

Thanx again !