friend request help

[quickstopman]

hey guys!

im working a friend request script

here is the code so far

<?
ob_start();
session_start();
include("config.php");
if(isset($_SESSION['userid'])) {
$sql = mysql_query("SELECT * FROM friends WHERE friendID = '{$_SESSION['userid']}' and accepted = 'no'") or die(mysql_error());
$friendreq = mysql_fetch_array($sql);
echo '<form method="post">';
while ($friendreq = mysql_fetch_array($sql)) {
echo "<input type='checkbox' name='ac[]' value='". $friendreq['fr_reqid'] ."'>  ";
echo "From: ". $friendreq['from'] ." ". $friendreq['fr_reqid'];
}
echo '<br><br><input name="accept" type="submit" value="Accept">
</form>';
if (isset($_POST['accept']) && count($_POST['ac']) > 0) { 
  // Make sure they are only attempting to delete their own messages!!! 
  $sql = "UPDATE  `friends` SET `accepted` =  'yes' WHERE  `friends`.`fr_reqid` = '{$friendreq['fr_reqid']}' LIMIT 1 ;' and userid = '{$_SESSION['userid']}'"; 
  if (!mysql_query($sql)) { 
    // Could not delete selected messages 
  } else { 
    // Successfully deleted messages
    echo "Successfully Deleted Messages";
  } 
} 
} else {
header ("Location:index.php");
}
?>

i wanna try to make it so the selected requests get accepted

or in my terms set accepted to yes

but the problom is that its really complicated

and it doesn't work

does anyone know a simpler way

or a way to fix the code i have?

thanks

[quickstopman]

quick bump