Query Help

[treeleaf20]

I have two columns in my database, user_id and friend_id. I want to select information if the person's id is in either one of these columns. I have the following query:

$query_num_friends = "SELECT COUNT(*) AS numrows FROM friends Where (user_id = '$_SESSION[Userid]' OR friend_id='$_SESSION[Userid]) AND confirm='Y'";

I get the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/debatesp/public_html/profile/profile.php on line 298

For one particular user I have their id in the friend_id column but not in the user_id column. I have another user with information in both columns and that doesn't work either so it is definately my query. Please help so I can make it correct.

Thank you

[subwayman]

echo the query string to the page before running the query and check EXACTLY what is passed to mysql. I think you will find it is not what you think it is.

[bbreslauer]

Well, your friend_id='$_SESSION..... doesn't have a closing quote on it. That could be the problem.

[tunage]

If you echo $query_num_friends does it look ok, does it run in MySQL?