I have a table I use to keep track of referred users on my top list. Below you will find the four columns in my table. What I need to do is keep entries (rows) unique based on the linkid, ipaddress, and the clicktype so that a user is not counted twice if they enter my site. Can someone tell me what I need to do?
historyid int(11) primary key linkid int(11) ipaddress varchar(15) clicktype char(3) __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]