table problem

[Scorchin]

hi, im trying to make a table to host a number of game servers. this table will be used to administer those servers. the problem that i am having, is in creating a drop-down list from the table.

The table is setup like this....

CREATE TABLE ip (
id int NOT NULL auto_increment,
box_number varchar(3) NOT NULL default '',
ip varchar(25) NOT NULL default '',
name varchar(50) NOT NULL default '',
email varchar(40) NOT NULL default '',
port varchar(7) NOT NULL default '',
end_date varchar(6) NOT NULL default '',
comments blob,
PRIMARY KEY (id),
);

the problem that i am having, is that each "ip" has 3 "box's" or game servers running off it. So within the "ip" field there are likely to be 3 duplicates of this data.
What i want to do is create a drop-down list for the ip's on a main admin section, this will show the different ip's and can then be selected. But when i do my query, due to my problem i get 3 of the same ip's loaded. when i only want a single ip to choose from. after this ip is chosen, the script will select from the table the entries which fit that given ip.

If someone can help me out by either helping me with the script, or redesigning the database, that will be great.

[TheDefender]

CREATE TABLE ip (
id int NOT NULL auto_increment,
box_number varchar(3) NOT NULL default '',
ip varchar(25) NOT NULL default '',
name varchar(50) NOT NULL default '',
email varchar(40) NOT NULL default '',
port varchar(7) NOT NULL default '',
end_date varchar(6) NOT NULL default '',
comments blob,
PRIMARY KEY (id),
);
Add a GROUP BY to your MySQL statement.

---

SELECT * FROM ip GROUP BY ip

---

If you have data stored like this, you may want or need to look into normalising your tables a bit so you don't duplicate your data... That's your call. You may not need to worry about it if you aren't going to have that much data in there.