Deleting duplicates on a webpage

[Jimmy2128]

I have the following code in a webpage and I need to remove duplicates. Can you please tell me based on the code the duplicates can be removed right from the page or I have been directed to somewhere in the database.. Thanks for your advise...

Jimmy

<tr>
<td align="right">Affiliate/Chapter:</td>
<td class="small" colspan="3">
<select name="ChapterID" onChange="document.Show.submit();">
<option value="">None
<option value="240">Australasia Affiliate
<option value="242">Australasia Affiliate
<option value="243">Australasia Affiliate - Brisbane
<option value="258">Australasia Affiliate - Brisbane

 

[r937]

since you have different values (primary keys?) for the same option name, you really should address this issue by resolving the duplicates in your database

if you don't know how to do this, then please indicate (a) which database system you're using, and (b) if you were going to delete all but one of the duplicates in your table, which one would you want to keep?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)