示例#1
0
 if ($sfcategory == 5) {
     $allsub = "General Student";
 } else {
     $titSQL = "SELECT `tutor_role`,`school`,`study` FROM `tutor_profile` WHERE `user_id` = " . $newOne['userid'] . "";
     $titRes = mysql_query($titSQL);
     $allsub = "";
     if (mysql_num_rows($titRes)) {
         $tutData = mysql_fetch_assoc($titRes);
         $allsub = @$tutData['tutor_title'];
         if ($tutData['tutor_role'] != '') {
             $allsub .= $tutData['tutor_role'];
             if ($tutData['school'] != '') {
                 $allsub .= " at " . $tutData['school'];
             }
             if ($tutData['study'] != '') {
                 $allsub .= " " . RaykuCommon::getTitlePre($tutData['tutor_role']) . " " . $tutData['study'];
             }
         }
     }
     if ($allsub == "") {
         $allsub = "Student";
     }
 }
 $query5 = mysql_query("select * from user_rate where userid=" . $newOne['userid'] . " ") or die(mysql_error());
 if (mysql_num_rows($query5) > 0) {
     $rowValues = mysql_fetch_assoc($query5);
     $rate = $rowValues['rate'] . "RP";
 } else {
     $rate = "0.00RP";
 }
 $curr_user_rank = '';