PHP: If no rows

Question

if ( $bid != $USER OR mysql_num_rows($already) > 0) {
    echo "ok";
}

I have this line. I want "ok" to show, if $bid isn't the same as $USER OR if there doesn't exists any rows in the $already query.

What have I done wrong?

function show_block_Form($bid, $id, $USER){
$already = mysql_query("SELECT * FROM users_blocked WHERE bID = '$bid' AND uID = '$USER'") or die(mysql_error());
if($bid != $USER || mysql_num_rows($already)==0){
echo "ok"
}
}

Please explain what does those lines mean in your script or we will not be able to understand if it right or wrong! — sh03
– sh03, Commented Nov 13, 2010 at 19:12
He's given enough information for us to help him with this. There's not more that he can explain, without going into all the details of his specific project. — Chris Laplante
– Chris Laplante, Commented Nov 13, 2010 at 19:14

Sarfraz · Accepted Answer · 2010-11-13 19:01:24Z

1

I want ok to show, if $bid isnt the smae as $USER *and* if there doesnt exists any rows in the $already query.

if($bid != $USER && mysql_num_rows($already) <= 0){

answered Nov 13, 2010 at 19:01

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sarfraz Over a year ago

You can then change it to or :)

Chris Laplante · Accepted Answer · 2010-11-13 19:08:44Z

1

if($bid != $USER OR mysql_num_rows($already)>0){

should be

if($bid != $USER || mysql_num_rows($already)==0){

edited Nov 13, 2010 at 19:08

answered Nov 13, 2010 at 19:01

Chris Laplante

29.7k18 gold badges109 silver badges137 bronze badges

14 Comments

Johnson Over a year ago

I meant OR.. I tried to do OR mysql_num_rows($already)==0 it still shows OK

Chris Laplante Over a year ago

I fixed it; that's what I thought you meant but I wasn't sure.

Johnson Over a year ago

okay, just tried that, it still shows. I tried to echo num_rows $already, and it outputs 1 so there is one row but still shows even with this restriction?!

Chris Laplante Over a year ago

My bet is that this is wrong: $bid != $USER. Try echoing $bid and $USER

Johnson Over a year ago

Ok update i just checked the if arguments. If i remove $bid != $USER, the num_rows works, if i remove num_rows the $bid != $USER works.. It cant handle two arguments at same time?

|

Collectives™ on Stack Overflow

PHP: If no rows

2 Answers 2

1 Comment

14 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

14 Comments

Your Answer

Sign up or log in

Post as a guest

Related