Similar to yesterday

$id_support contains 8 results $id_traffic contains 0 results (this is correct) $id_card returns a *single* result when it should return an amount equal to the number of records retrieved by $id_support + $id_traffic. So, if $id_support returns multiple records as an array and $sql_card is a query that looks for records in a table based on $id_support, shouldn't it return the multiple records? // Select all child support requests that are ready to be processed $sql_support ="SELECT * FROM support_payment_request WHERE status_code = 'P'"; $result_support = mssql_query($sql_support) or die(mssql_error());

     if(!empty($result_support)) {
        while ($row_support = mssql_fetch_array($result_support)) {
           $id_support = $row_support['_card_id'];
           print_r ($id_support);  // This returns multiple records
               }
           }

// Select all traffic/criminal requests that are ready to be processed $sql_traffic ="SELECT * FROM traffic_criminal_payment_request WHERE status_code = 'P'"; $result_traffic = mssql_query($sql_traffic) or die(mssql_error());

     if(!empty($result_traffic)) {
        while ($row_traffic = mssql_fetch_array($result_traffic)) {
           $id_traffic = $row_traffic['credit_card_id'];
           print_r ($id_traffic);  // This currently returns no records

since all have been processed

               }
           }

/* Select all credit_card records where the child support and traffic/criminal records have the same credit_card_id and have a status of "P" */ $sql_card = "SELECT * FROM payment_request WHERE card_id = '$id_support' OR card_id = '$id_traffic'"; $result_card = mssql_query($sql_card) or die(mssql_error()); ?> <table width='780' border='1' align='center' cellpadding='2' cellspacing='2' bordercolor='#000000'> <?php if(!empty($result_card)) {

      while ($row_card = mssql_fetch_array($result_card)) {
         $id_card = $row_card['card_id'];
         $dateTime = $row_card['date_request_received'];
         print_r ($id_card);

?> <tr> <td width='88' height='13' align='center' class='tblcell'><div align='center'><?php echo "<a href='javascript:editRecord($id_card)'>$id_card</a>" ?></div></td> <td width='224' height='13' align='center' class='tblcell'><div align='center'><?php echo "$dateTime" ?></div></td> <td width='156' height='13' align='center' class='tblcell'><div align='center'><?php echo "To Be Processed" ?></div></td> <td width='156' height='13' align='center' class='tblcell'><div align='center'><?php echo "Payment Type" ?></div></td> <td width='156' height='13' align='center' class='tblcell'><div align='center'><?php echo "Last Processed By" ?></div></td> </tr> <?php

       }

} else { echo "<br>"; } ?> </table>