code help

[jasondavis]

The code below no matter what returns 0, what is wrong?

function check_friend($userid, $friendid) {
    $sql = "SELECT userid FROM friend_friend
                WHERE userid='$userid'
                    AND friendid='$friendid'
					AND status='1'
                LIMIT 1";
	$result = executeQuery($sql);
	if ($line = mysql_fetch_assoc($result))
		return 1;
	else
		return 0;
}

[NogDog]

What does the executeQuery() function do? (In particular, what does it return?)

[jasondavis]

here is that function

function executeQuery($sql) {
	$result = mysql_query($sql) or die("<span style='FONT-SIZE:11px; FONT-COLOR: #000000; font-family=tahoma;'><center>An Internal Error has Occured. Please report following error to the webmaster.<br><br>" . $sql . "<br><br>" . mysql_error() . "'</center></FONT>");
	return $result;
}

[NogDog]

Well, if we get as far as returning 0 from the check_friend() function, it would seem the only reason would be if the query returned no rows. Maybe to help debug you could throw in an echo of $sql in that function to make sure the query looks right, and perhaps copy-and-paste it into a command line mysql session or phpMyAdmin, and make sure the query is doing what you want.

[sharifbaba]

check for return values ,
i think no rows in ur table...