mysql - writing sql query with php prepared query -

i trying write mysql query php prepared query.

first, query

    $query="delete friends  usera=?, userb=?      or (userb=?, usera=?)"; 

i want delete friends entry database. entry can in order. like, friends relation can entered usera friend of userb or userb friend of usera. there 1 entry anyway. check make sure entry deleted trying find , delete in of both possible cases.

second,
confused passing parameters above sql query. parameters in above query four. guessing pass 4 parameters. think if $stmt->bind_param('ii',$useraid, $userbid) should work???

$stmt=$mysqli->stmt_init(); $stmt->prepare($query); $stmt->bind_param('iiii',$useraid, $userbid, $useraid, $userbid); $stmt->execute();  

lets sum up:

/* fixed query */ $query="delete friends (usera=? , userb=?) or (userb=? , usera=?)";  /* invoke query */ $stmt=$mysqli->stmt_init(); $stmt->prepare($query); // (1 parameter each "?" ) $stmt->bind_param('iiii',$useraid, $userbid, $useraid, $userbid); $stmt->execute();