I have a similar problem but not with the clicking but with filling out a survey that is captured in mysql, twice.
Any help would be appreciated Albert ----- Original Message ----- From: "Joseph" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 31, 2003 2:07 AM Subject: uniques, keys, etc? > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
