[RESOLVED] searching a table for a record, if found return true

[trehy2006]

Basically I have a table named friends which has two fields.

One field called fid and the other mid

mid, needs to equal $user['id']
fid, needs to equal $_GET['userid']

What i need to do is search the table to see if there is a record where those two are set.

mid and fid have to equal my variables in the same row of the table...

if they do I need the script to return true, else obv. return false!!

How do I do this, I don't have a clue with this one!!

[devinemke]

$result = mysql_query("SELECT COUNT(*) FROM friends WHERE mid = '" . $user['id'] . "' AND fid = '" . $_GET['userid'] . "'") or exit(mysql_error());
if (mysql_result($result, 0)) {echo 'yes';} else {echo 'no';}

[trehy2006]

Thanks