The best way to query tables and loop through returning rows is to run a SELECT statement with the mssql_query() function, catch the returning object as a result set, and loop through the result with mssql_fetch_array() function in a while loop as shown in the following sample PHP script:

<?php

$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');

mssql_select_db('GlobalGuideLineDatabase', $con);

$sql = "SELECT id, url, time FROM ggl_links";

$res = mssql_query($sql,$con);

while ($row = mssql_fetch_array($res)) {

print($row['id'].",".$row['url'].",".$row['time']." ");

}

mssql_free_result($res);

mssql_close($con);

?>