php/mysql question

[Gruzin]

Hi everyone,

 

I'am having some trouble with mysql select... say I have a field DrugID (INT) and there are some records in it (2, 6, 12, 12).

 

if there are two or more same records, like 12 three times, how can I detect that?

 

hope you understand me, if not please let me know...

 

Thanks,

George

 

 

[almightyegg]

$query = mysql_query("SELECT * FROM `table` WHERE DrugID='12'");

$query2 = mysql_num_rows($query); //counts how many ids = 12

 

[Gruzin]

Thanks but, I don'r really know exact number, I mean:

$query = mysql_query("SELECT * FROM `table` WHERE DrugID='$var'");

 

Thanks,

George

 

[Jessica]

So what's the problem?

[Gruzin]

OK, here is my test script:

 

$apt = mysql_query("SELECT DrugRemainder.MatID,Drugstores.DrugID FROM DrugRemainder,Drugstores WHERE (DrugRemainder.MatID='$id' AND Drugstores.DrugID=DrugRemainder.DrugID)");

 

and I don't want to show same results, I mean if there is a record 12 three times I want to count it as one.

 

 

Thanks,

George

[Jessica]

Use the MYSQL DISTINCT keyword.

http://dev.mysql.com/doc/refman/5.0/en/select.html

[Gruzin]

Yeeeee!

 

Thanks jesirose, I'am happy 

[Jessica]

Also, if you're trying to find out how many, not just get unique, you can use count()

[Gruzin]

OK, but DISTINCT works just fine,

 

Thank you again,

George