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
