check if record exist

[chrianne29]

I need to seek suggestions on how to check if there are two data that exist in my database. I'm currently building a search engine which looks for data inside my database. I already build it but every time I enter an item and try to search it, the system outputs 2 data or more if the search item is already existing. What I want to do is when I try to search an item the system will tell me that ITEM#1 and ITEM#2 exist. Is there any code which I can used to output this one? I will wait your reply. Thanks.

[sneakyimp]

to see if a record exists, you should probably use a SELECT statement.

[bradgrafelman]

Can you show us the DB schema as well as some sample data?