selecting one row

[almightyegg]

i am trying to select a members group, but the name of it isnt stored in member database, the group id is.
so i wanted to try selecting the name from the group database, using the member group id...i hope that made sense :P
[code=php:0]
$society = mysql_query("SELECT * FROM cluth WHERE id LIKE '%$mem[clutch]%'");
$soc2 = mysql_fetch_array($soc2);
?>
Clutch: <? echo "$soc2[name] $mem[clutch]"; ?><br>
[/code]

anyideas???

[fenway]

I'm not sure I understand... first, you're getting back multiple rows, assuming your query executes correctly.  What's the problem?