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

[Back to original message]