Detecting multiple instances of data in MYSQL table

[chris_2001]

What I want to do is check if there are any IDs in a mysql table that are the same as eachother for the same username.

$info = odbc_exec($con,"SELECT ItemID FROM DATABASE WHERE strUserID = '".$user."'");
$ID = odbc_result($results, 1);

There will be multiple ItemIDs where strUserID is equal to $user and i want to check if ItemID is the same in two places. Sorry for repeating myself just trying to make it clear. It is probably quite easy to do I just have no idea how. Thanks for your time.

[leatherback]

hm...
Something like:
"select count(ItemId) as count from database where strUserID = '".$user."' and count > 1 group by strUserID "

[chris_2001]

leatherback wrote:

hm...
Something like:
"select count(ItemId) as count from database where strUserID = '".$user."' and count > 1 group by strUserID "

This looks like it would only check if there were more than 1 ItemID not if two of them are the same, there will be up to 40 ItemIDs but none of them should be the same. I want to check if any are the same.

[leatherback]

you are right, got th wrong grouping column:

"select ItemID, count(ItemId) as count from database where strUserID = '".$user."' and count > 1 group by ItemID "

[chris_2001]

What would I do next?

$ItemID = odbc_result($ID, 1);


If (is_null($ItemID) {
stuff here
}

[leatherback]

I dunno. You wanted to detect mutliple instances of some ID for a specific user. What you would like to do with it... I dunno...

[chris_2001]

leatherback wrote:

I dunno. You wanted to detect mutliple instances of some ID for a specific user. What you would like to do with it... I dunno...

What I meant is

$ItemID = odbc_result($ID, 1);


If (is_null($ItemID) {
stuff here
}

would this work minus the stuff here part?

the is_null thing and the odbc_result thing

[HalfaBee]

You don't want to check for null.

if( $ItemID ) {
// do stuff here
}