469,271 Members | 1,697 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Selecting first occurance in a given period of record

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 |
+---------------+-------------+------+-----+---------+-------+
| 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
Jul 19 '05 #1
0 708

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by don | last post: by
9 posts views Thread by Ray | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.