executeQuery($sql, []); if ($count_new === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } $new_row = $count_new[0]; $total_mobile_deals = $new_row['total']; $sql = 'SELECT COUNT(ringtone_order_id) AS total FROM ringtone_order WHERE status = "open"'; $count_upd = $pdoWrapperObj->executeQuery($sql, []); if ($count_upd === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } $upd_row = $count_upd[0]; $total_open_orders = $upd_row['total']; $sql = 'SELECT COUNT(ringtone_order_id) AS total FROM ringtone_order WHERE status = "closed"'; $count_proc = $pdoWrapperObj->executeQuery($sql, []); if ($count_proc === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } $proc_row = $count_proc[0]; $total_closed_orders = $proc_row['total']; ?>

Ringtone Order Summary

Total Mobile Deals
Open Ringtone Orders
Completed Ringtone Orders