According to the php manual it´s done either with mssql_fetch_row(int result) or with mssql_fetch_array(int result). Both returns an array that corresponds to the fetched row, or false if there are no more rows.
The result variable in your case is $send_mail_to_link_partners.
ex.
while ($row = mssql_fetch_array($result)) {
echo $row[field];
}
//N.B