Perhaps I am missing something, but it looks to me as if this example found on http://php.weblogs.com/odbc is exactly what you need:

// connect to a DSN "mydb" with a user and password "marin" 

$connect = odbc_connect("mydb", "marin", "marin");



// query the users table for name and surname

$query = "SELECT name, surname FROM users";



// perform the query

$result = odbc_exec($connect, $query);



// fetch the data from the database; 

// add the counter and your 10 rows only criterion

while(odbc_fetch_row($result)){

  $name = odbc_result($result, 1);

  $surname = odbc_result($result, 2);

  print("$name $surname\n");

}



// close the connection

odbc_close($connect);

?>

Dragi "Bonzi" Raos
Zagreb, Croatia
Q#5196, MkII#80000376, 18GB green