Iterate Over Drupal DB Result Set

How to loop over a DB Result set in Drupal 6

$uid = 1;
$result = db_query("SELECT n.nid, n.title, n.created
                             FROM {node} n 
                             WHERE n.uid = %d", $uid);
while ($record = db_fetch_object($result)) {
  // Perform operations on $record->title, etc. here.
}