How to allow duplicate entry in a table

[alex_bg]

Hello... I got stuck with my php poll. I need to have duplicate entry in my database, as everyone of my voters may vote for more than 1 option in my poll. But when I try to record their voting I get:
"Duplicate entry for key 1"... pls help me!

My code looks like that:
// lock ip
if (isset($tapps_ip_locking) && $tapps_ip_locking==TRUE)
foreach ($options as $option_id)
{
$ip = $HTTP_SERVER_VARS['REMOTE_ADDR'];
db_query("INSERT INTO tapps_iplocks (poll_id,ip,option_id) VALUES($poll_id,'$ip','option_id')");
}

Please help with an advise.

[barand]

I don't know the structure of your table but Im guessimg that poll_id is the id of the voter and is the primary key which does not allow allow duplicates.

If that is right, set up a recordid as primary and just have an ordinary index on poll_id.

Alternatively, have a second table containing the options voted for by each voter and leave pollid as the primary in the main table.

The choice is yours.

hth

[alex_bg]

Thank you, thank you so much barand!
That really worked!