Retrieving Results of a Query to MSSQL
$result = mssql_query();
mssql_fetch_assoc($result);
|
Finally, there is, of course, also a way to retrieve all data in the resultset. A while loop comes into play, using one of these functions:
mssql_fetch_assoc() returns the current row in the resultset as an associative array mssql_fetch_object() returns the current row in the resultset as an object mssql_fetch_row() returns the current row in the resultset as a numeric array
Retrieving Data from MSSQL/MSDE (mssql_fetch.php; excerpt)
<table>
<tr><th>#</th><th>Quote</th><th>Author</th><th>Year<
/th></tr>
<?php
if ($db = @mssql_connect('localhost', 'user',
'password')) {
mssql_select_db('phrasebook', $db);
$result = mssql_query('SELECT * FROM quotes',
$db);
while ($row = mssql_fetch_assoc($result)) {
printf(
'<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></
tr>',
htmlspecialchars($row['id']),
htmlspecialchars($row['quote']),
htmlspecialchars($row['author']),
htmlspecialchars($row['year'])
);
}
mssql_close($db);
} else {
echo '<tr><td colspan="4">Connection
failed.</td></tr>';
}
?>
</table>
|