Just a first glance, Dan, but try this: $sql_record ="SELECT * FROM payment_request WHERE status_code = 'P'"; $result_record = mssql_query($sql_record) or die(mssql_error()); if(!empty($result_record)) { while ($row_record = mssql_fetch_array($result_record)) { echo $row_record['id']; } } That should echo all of the data in the 'id' column from the matching rows. -- Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107