Hello all,
My script works fine as it is, but I am trying to reduce the number of
queries to the database. I am running PHP 4.3.4 and MySQL 4.0.3.
Here is my table structure:
mysql desc application;
+-+--+--+-+-+---
-+
| Field
using grouping:
SELECT count(application.*), application.media_ID, mailbox.company_ID
FROM application, mailbox
WHERE mailbox.app_ID = application.ID
GROUPBY mailbox.company_ID, application.media_ID
SQL is unchecked;
try to look at the problem from the other direction
determine what information