$q = "SELECT DISTINCT pr.`reminder_level`, o.`jng_sp_orders_id`,o.customer_billing_address, c.* FROM `payone_invoice` p\nINNER JOIN `payone_reminder` pr ON pr.invoice_id = p.invoice_id\nINNER JOIN `jng_sp_orders` o ON o.`jng_sp_orders_id` = p.`invoice_order_id`\nINNER JOIN `jng_sp_customers` c ON c.`customer_id` = o.`customer_billing_id`\nWHERE pr.`reminder_level` = (SELECT reminder_level FROM payone_reminder WHERE invoice_id = p.invoice_id and reminder_level in ('5','A') ORDER BY info_received DESC LIMIT 1)\nAND o.`jng_sp_id` = 2\nand c.jng_sp_customers_id not in (14402,14433)\norder by c.customer_firstname"; $dbq = tep_db_query($q); echo "<table border='1'>\n <tr>\n <td><b>NO.</b></td>\n <td><b>REMINDER LEVEL</b></td>\n <td><b>ORDERS ID</b></td>\n <td><b>FIRSTNAME</b></td>\n <td><b>LASTNAME</b></td>\n <td><b>ADDRESS</b></td>\n <td><b>BAC</b></td>\n <td><b>AC</b></td>\n <td><b>CS</b></td>\n </tr>"; $n = 0; $bac = null; $ac = null; $cs = null; while ($r = tep_db_fetch_array($dbq)) { $order_id = $r['jng_sp_orders_id']; $n++; echo "<tr>"; echo "<td>{$n}</td>"; echo "<td>{$r['reminder_level']}</td>"; echo "<td>{$r['jng_sp_orders_id']}</td>"; echo "<td>{$r['customer_firstname']}</td>"; echo "<td>{$r['customer_lastname']}</td>"; echo "<td>{$r['customer_billing_address']}</td>"; $bac = $class_payone->payoneCustomerBankAccountCheck($order_id); echo is_null($bac) ? "<td> </td>" : "<td>{$bac['status']}</td>"; $ac = $class_payone->payoneCustomerAddressCheck($order_id); echo $ac['status'] == 'VALID' ? "<td>{$ac['secstatus']}</td>" : "<td> </td>"; $cs = $class_payone->payoneCustomerConsumerScore($order_id); echo $cs['status'] == 'VALID' ? "<td>{$cs['secstatus']} ( {$cs['score']} )</td>" : "<td> </td>"; echo "</tr>"; } echo "</table>"; //echo $str; //$result_test = $class_payone->payoneCustomerBankAccountCheck('6806');//14876 //$result_test = $class_payone->payoneCustomerAddressCheck('20820'); //$result_test = $class_payone->payoneCustomerConsumerScore('6806'); //echo "<pre>";var_dump($result_test);