mysql query

Hello,

I've thought about this a lot, but no ideas.

I issue a normal mysql query to obtain records, ordered by some_column.

SELECT some_col FROM mydb ORDER BY some_col DESC

Once I have my records from the db, I now need to know if any records have the same values.

Example:

Let's say my records are :

tom
samuel
samuel
samuel
mark
jake
jake
doug
doug

Is there a way to tell that samuel, jake, and doug all occur more than once?

TIA,

Richie.

any particular reason u need this cause if u want them to appear only once u can use

select distinct(colname) from mytable order by colname

reg
kevin

I need to take an action, only if a particular record occurs multiple times.

oops.... nm....

ok what u need to do is to put the values in a array, as u loop thru the result. then use this function

reg
kevin

Just what I need.

I haven't tried it yet, but I'm sure you're right on the money.

Thanks a lot.

Richie.

One question that I do have is how to set up a condition that will check for the value of each category in the array_count.

Example given in the manual is:

$array = array (1, "hello", 1, "world", "hello");
print_r(array_count_values ($array));

The printout of the above program will be: Array
(
[1] => 2
[hello] => 2
[world] => 1
)

How can I use the value of hello in a conditional statement like this:

IF( [hello] > 1 ) { STATEMENT... }

Thanks again...

foreach($array as $key=>$value){
	if($value > 1){
		echo $key." has value = ".$value;
 }
}

reg
kevin

You've been most helpful. Thanks.

can u mark this resolved if ure done, there is a link below
thanks
reg
kevin