|
|
Posted by flouger on 11/20/06 09:05
Im trying to write the following query to do the following but im not
sure about the right way to do it
I want to get back all the results minus any results that are within
the 3 minutes of each other containing the same ip address, and same
owner information.
Basicly I want to filter out multiple entries with different times.
the database looks like this.
`owner` int(11) NOT NULL default '0',
`visitor` int(11) NOT NULL default '0',
`visittime` timestamp(14) NOT NULL,
`ip` varchar(16) NOT NULL default ''
I Imagine I need to use a time diff function but am not really sure how
to implement that in.
Thanks
Navigation:
[Reply to this message]
|