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

<?php

$con = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');

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

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

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

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

}

odbc_free_result($res);

odbc_close($con);

?>

Using odbc_fetch_array() is better than other fetch functions, because it allows you to access field values by field names. If you run this script, you will see all rows from the ggl_links table are printed on the screen:

101,rendc.org,

102,rendc.org/sql,

1101,rendc.org/html,

1102,rendc.org/xml,

2101,rendc.org/xslt,

2102,rendc.org/seo,

Don't forget to call odbc_free_result($res). It is important to free up result set objects as soon as you are done with them.