Jump to content


Photo

selecting one row


  • Please log in to reply
1 reply to this topic

#1 almightyegg

almightyegg
  • Members
  • PipPipPip
  • Advanced Member
  • 791 posts
  • LocationEngland

Posted 24 October 2006 - 10:22 AM

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
$society = mysql_query("SELECT * FROM cluth WHERE id LIKE '%$mem[clutch]%'");
$soc2 = mysql_fetch_array($soc2);
?>
Clutch: <? echo "$soc2[name] $mem[clutch]"; ?><br>

anyideas???
Visit my Game - Under Construction

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 October 2006 - 03:38 PM

I'm not sure I understand... first, you're getting back multiple rows, assuming your query executes correctly.  What's the problem?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users