Heres the select i'm using now:

$query = "
SELECT UNIX_TIMESTAMP(usageWhen),UNIX_TIMESTAMP(usageOtherTime),usageUser
FROM KSUsage
        LEFT JOIN KSComputers ON KSUsage.usageComputerID = KSComputers.computerID
WHERE KSComputers.computerDivisionID = '$division_id'
        AND usageEvent = 16
        AND ( usageWhen > FROM_UNIXTIME('$start_time') OR usageOtherTime > FROM_UNIXTIME('$start_time') )
        AND ( usageWhen < FROM_UNIXTIME('$end_time') OR usageOtherTime < FROM_UNIXTIME('$end_time') )
ORDER BY usageWhen";

What i need is a list of time and the number of logins at that time... for example


(TIMESAMP => 5, TIMESTAMP => 6 ...)

The usageWhen is the logout time, the usageOtherTime is the login time.

mysql> describe KSUsage;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| usageID         | varchar(128) |      | PRI |         |       |
| usageWhen       | datetime     | YES  |     | NULL    |       |
| usageEnum       | int(11)      | YES  |     | NULL    |       |
| usageServerID   | int(11)      | YES  |     | NULL    |       |
| usageServerType | int(11)      | YES  |     | NULL    |       |
| usageProgramID  | varchar(48)  | YES  |     | NULL    |       |
| usageLicenseID  | varchar(32)  | YES  |     | NULL    |       |
| usageComputerID | varchar(64)  | YES  | MUL | NULL    |       |
| usageExpansion  | varchar(64)  | YES  |     | NULL    |       |
| usageUser       | varchar(64)  | YES  |     | NULL    |       |
| usageAddress    | varchar(32)  | YES  |     | NULL    |       |
| usageGroup      | varchar(64)  | YES  |     | NULL    |       |
| usageEvent      | int(11)      | YES  |     | NULL    |       |
| usageReason     | int(11)      | YES  |     | NULL    |       |
| usageTime       | int(11)      | YES  |     | NULL    |       |
| usageOtherTime  | datetime     | YES  |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
16 rows in set (0.00 sec)

Example ROW:

| 413722F600000C34002C7233 | 2004-09-02 09:41:10 |      3124 |       2912819 |               0 | 362E302E302E38 | NULL           | N00:03:93:B1:47:BE | NULL           | sigler62  | 137.143.100.45 | NULL       |         16 |           0 |         1 | 2004-09-02 09:41:11

mysql> describe KSComputers;
+-----------------------+--------------+------+-----+---------+-------+
| Field                 | Type         | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+-------+
| computerID            | varchar(64)  |      | PRI |         |       |
| computerServerID      | int(11)      |      | PRI | 0       |       |
| computerName          | varchar(64)  | YES  |     | NULL    |       |
| computerUserName      | varchar(64)  | YES  |     | NULL    |       |
| computerPlatform      | int(11)      | YES  |     | NULL    |       |
| computerProtocol      | int(11)      | YES  |     | NULL    |       |
| computerAddress       | varchar(32)  | YES  |     | NULL    |       |
| computerOSType        | int(11)      | YES  |     | NULL    |       |
| computerOSVersion     | int(11)      | YES  |     | NULL    |       |
| computerOSRelease     | int(11)      | YES  |     | NULL    |       |
| computerCPUType       | int(11)      | YES  |     | NULL    |       |
| computerCPUCount      | int(11)      | YES  |     | NULL    |       |
| computerCPUClock      | int(11)      | YES  |     | NULL    |       |
| computerRAMSize       | int(11)      | YES  |     | NULL    |       |
| computerDiskSize      | int(11)      | YES  |     | NULL    |       |
| computerFreeSpace     | int(11)      | YES  |     | NULL    |       |
| computerMACAddress    | varchar(64)  | YES  |     | NULL    |       |
| computerSite          | varchar(64)  | YES  |     | NULL    |       |
| computerOEMSerial     | varchar(64)  | YES  |     | NULL    |       |
| computerOSSerial      | varchar(64)  | YES  |     | NULL    |       |
| computerLastLogin     | datetime     | YES  |     | NULL    |       |
| computerLastAudit     | datetime     | YES  |     | NULL    |       |
| computerBaseAudit     | datetime     | YES  |     | NULL    |       |
| computerClientVersion | varchar(16)  | YES  |     | NULL    |       |
| computerUserSession   | int(11)      | YES  |     | NULL    |       |
| computerAcknowledged  | int(11)      | YES  |     | NULL    |       |
| computerAllowed       | int(11)      | YES  |     | NULL    |       |
| computerAudit         | int(11)      | YES  |     | NULL    |       |
| computerDivisionID    | int(11)      | YES  |     | NULL    |       |
| computerAssetID       | varchar(64)  | YES  |     | NULL    |       |
| computerLocation      | varchar(64)  | YES  |     | NULL    |       |
| computerConfirmed     | datetime     | YES  |     | NULL    |       |
| computerConfirmedBy   | varchar(64)  | YES  |     | NULL    |       |
| computerNotes         | varchar(255) | YES  |     | NULL    |       |
| computerFlags         | int(11)      | YES  |     | NULL    |       |
+-----------------------+--------------+------+-----+---------+-------+
35 rows in set (0.00 sec)