query("SELECT * FROM USERS WHERE (ADMIN != 1 OR ADMIN IS NULL) AND store_type = 1"); while ($row = $res->fetchArray()) { $id = $row["id"]; $name = $row["NAME"]; $username = $row["USERNAME"]; $macs = $row["mac_amount"]; $macsUsed = $db2->query("SELECT COUNT(*) as count FROM ibo WHERE id_user = '$id' AND active = 1 AND expire_date > date('now')"); $macsUsed = $macsUsed->fetchArray()['count']; $macsAvailable = $macs - $macsUsed; echo " \n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo "\t\t\t\t\n\t\t\t\n"; } echo "\t\t\t

ID	Name	Username	MACs	Available MACs	Edit	Delete
" . $id . "	" . $name . "	" . $username . "	" . $macs . "	" . $macsAvailable . "

\n\t\t