Wp_grades

<?php
$groupid=0;
$groupid=$_POST['group_id'];
$groupname=$_POST['group_name'];
$groupgrade=$_POST['group_grade'];
$groupformat=$_POST['group_format'];
$groupprivatecomment=$_POST['group_prv_comment'];
$grouppubliccomment=$_POST['group_pub_comment'];
$assignmentname=$_POST['assignment-name'];
echo "you have entered" ;
echo $groupid.$groupname;
$link = mysql_connect('HOST_ADDRESS', 'USERNAME', 'PASSWORD');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo '<br>The Grades are being entered .Please check for the confirmation message below<br>';
$db_selected = mysql_select_db('u671706493_upuVy', $link);
if (!$db_selected) {
    die ('Can\'t use wordpress : ' . mysql_error());
    }
    echo "<br>database selected sucessfully<br>";
    if ($groupid==0) {
    $sql2 = " SELECT id FROM  wp_bp_groups WHERE name='$groupname'";
    $groupi= mysql_query($sql2);
        if (!$groupi) {
    echo "Could not successfully run query ($sql2) from DB: " . mysql_error();
    exit;
    }
    $groupid = mysql_result($groupi,0,0);
        echo $groupid ;

    }
    $sql = "SELECT user_id FROM `wp_bp_groups_members` WHERE group_id=$groupid AND user_title !=\"Group Admin\"";
    $result1 = mysql_query($sql);
    if (!$result1) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();

    exit;
}
$row = mysql_fetch_assoc($result1);
print_r ($row);
echo '<br>'2;
$sql3 = "SELECT ID FROM  `wp_posts` WHERE post_title = '$assignmentname' ";
    $result2 = mysql_query($sql3);
    if (!$result2) {
    echo "Could not successfully run query ($sql3) from DB: " . mysql_error();
    exit;
}
    $parent_post = mysql_result($result2,0,0);
    $sql4 = "SELECT ID FROM  `wp_posts` WHERE post_parent = $parent_post AND post_type='gradebook' ";
    $result4 = mysql_query($sql4);
    if (!$result4) {
    echo "Could not successfully run query ($sql4) from DB: " . mysql_error();
    exit;
}
    $post_id = mysql_result($result4,0,0);
    echo "post id is $post_id <br>";

if (mysql_num_rows($result1) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}
$sql7 = "SELECT meta_id FROM wp_postmeta where meta_key='grade' AND post_id = $post_id";
$result7 = mysql_query($sql7);

while ($row = mysql_fetch_assoc($result1) && $row2 = mysql_fetch_assoc($result7)) {
    echo $row2["meta_id"], ' => ', $row["user_id"];
    $new    = "[grade uid=\"{$row["user_id"]}\" value=\"{$groupgrade}\" format=\"{$groupformat}\" prv_comment=\"{$groupprivatecomment}\" pub_comment=\"{$grouppubliccomment}\"] ";
    $sqq    = "UPDATE wp_postmeta SET meta_value='$new' WHERE meta_key='grade' AND post_id= $post_id AND meta_id = {$row2["meta_id"]}";
    $result = mysql_query($sqq);
    echo "grade has been updated";
}



mysql_close($link);
?>