elis Posted September 28, 2006 Share Posted September 28, 2006 My MYSQL table looks like this: [b]id username blocked[/b]1 Bob Jack21 Bill Bob4 Bob JaneThe problem is, when I call up this table with [code]bresult = mysql_query("SELECT * FROM blocks WHERE username = '$recip'");$cresult = mysql_fetch_array($bresult);[/code]Say, $recip = Bob, so the username [i]Bob[/i] is called up; and then I compare if with "IF...$userusername ==cresult[blocked]..."so that if a user is blocked by Bob, they can't contact him.The problem with this is, if you look at the table, Bob as two people blocked in two rows: Jane and Jack.So if Jack is trying to contact Bob, he's obviously blocked - but the MYSQL arrangment will read Jane as being blocked and let Jack contact Bob. (I'm sorry if this is getting confusing, I'm fairly poor at explaining things).So I need a method where the Select function will get the ID, since it's the only independent value, but I'm not sure how to go about this as I don't know what to put for "WHERE ________ = ___________" . (Or if anyone has any other ideas, they'd be much appreciated too.) Quote Link to comment Share on other sites More sharing options...
alpine Posted September 28, 2006 Share Posted September 28, 2006 Unless i totally misunderstood you - run it through a while loop[code]<?php$block = false;$bresult = mysql_query("SELECT * FROM blocks WHERE username = '$recip'");while($row=mysql_fetch_array($bresult)){ if($row["blocked"] == $userusername) { $block = true; break; }}if($block == true){ echo "User har blocked you, sorry";}else{// proceed}?>[/code] Quote Link to comment Share on other sites More sharing options...
elis Posted September 28, 2006 Author Share Posted September 28, 2006 Thanks! That worked perfectly! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.