I want to add a table to an existing database to enable a ratings script and to track which IP has voted for each item. The only information I need in this table are:
the id of the item
the ip numbers that voted for this item

Each item id number will be unique as that is pulled from another table. Each id number will have multiple ip numbers voting for it.

If I only have two fields ID and IP then there will be multiple entries for each ID. Make the Ip the primary key and index the item number?

Is this the best way to do this? Looking for speed and ease on the server.

I'd go to two tables,

One for IPs (plus an ID column), indexed on the IP column, and a relational table of item IDs and IP IDs

I may try that. What I posted above did not work.

Right now I have a single table with id and ip, indexed on id with no primary and I can post with multiple (faked for testing ) IPs. But this is going to become a long table on a popular site as each entry is a seperate row.

Maybe that isn't as bad as it sounds since the select process is where id and ip = the designated items.