MySQL Forums
Forum List  »  PHP

Avoiding Duplicate entries
Posted by: Raghav Khanna
Date: August 20, 2012 12:42PM

Hi
my query is
i have a table named drugs and it has all the drugs listed with the corresponding manufacturer id

now a same drug is manufactured by multiple manufacturers
for eg:-
paracetamol is manufactured both by ranbaxy and cipla
so i have to make two entries for paracetamol in my table

Now i want to display this table in front end

but some entries are displayed twice,which i dont want
like for above example
paracetamol is displayed twice in front end since it has been entered twice in backend

but i want that it should be displayed only once in front end

can anyone help me with it as to how i can filter my duplicate entries and prevent them from getting displayed

Thanking you in advance

Options: ReplyQuote


Subject
Written By
Posted
Avoiding Duplicate entries
August 20, 2012 12:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.