Selecting first occurance of record in a given period

scuk

Hi,

I have a table to log sessions and user (connect_id) id's, start time etc - see below

+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| bt_connect_id | varchar(12) |      |     |         |       |
| session_id    | varchar(32) |      |     |         |       |
| start_time    | int(11)     |      |     | 0       |       |
| client_ip     | varchar(16) |      |     |         |       |
+---------------+-------------+------+-----+---------+-------+

I need to create a report that will tell me, for instance, how many sessions were started today, that's easy I know but I also need another report that will tell me how many of those sessions were first-time visitors.

FYI the start_time is a UNIX timestamp..

Any help would be greatly appreciated!

Cheers

Stew

KITTfan2K

Number of sessions started:

$Query = mysql_query ("SELECT DISTINCT(`session_id`) FROM `table_name`;");
$Count = mysql_num_rows ($Query);
echo $Count;

That was just to get me started.

Now...

$Date = mktime (0, 0, 0, date ("d"), date ("m"), date ("Y"));
$Query = mysql_query ("SELECT DISTINCT(`session_id`) FROM `table_name` WHERE `start_time` > 'Date';");
$Count = mysql_num_rows ($Query);
echo $Count;

I think that that should bring back anything where the start_date is 'today' (I think!)

You've got me curious now, what does the bt_connect_id do?

KITTfan2K