All you have to do is run a select statement looking for the value you just inserted. This goes right after your insert statement.
Here's some pseudo code:
1. insert into table(field1) values('value')
2. y = select count(field1) from table where field1 = 'value'
3. if (y == 1)
just one exists
elseif( y > 1)
multiple exist
If you need more help let us know.
Reputation Points: 262
Solved Threads: 18
a.k.a inscissor
Offline 1,227 posts
since Feb 2002
Unsolved 
