mattock

Hi I'm trying to re-write a simple 'while' loop in php.  I have had to transfer hosts, my old host had MYSQL and i could connect simply by using @mysql_connect.  How ever, my new host is MS SQL and i have to connect using ODBC. This is my old php code i'm trying to convert to MS SQL/ODBC $result = @mysql_query ($query); $row = @mysql_fetch_array ($result, MYSQL_NUM); if ($result) { while ($row = mysql_fetch_assoc($result)) { echo $row['id']; } } I have managed to connect to the database using ODBC ( $result = odbc_exec($conn, $query); ), but i'm not sure what syntax is needed to do the rest! Thanks in advance