how to get particular id from mysql db

[vijay005]

<?php
 
    $result = mysql_query("SELECT user_id,cb_parentid FROM comprofiler ");
    while($row = mysql_fetch_array($result))
    {    
     echo "<td>" . $row['cb_parentid'] . "</td>\n <br/>";    
 
    }    
?>

i want calculation on particular parent_id but there is problem how can i take particular parent if form while loop. if any one can suggest me how can is possible.

[vijay005]

function earning($user_id1)
{
    $income=0;
    $sql_earn="SELECT * FROM jos_comprofiler where cb_parentid='".$user_id1."'";
    $result_earn = mysql_query($sql_earn);
    while($row_earn = mysql_fetch_array($result_earn))
    {
        if($row_earn['cb_package']=='Basic Details Rupees 3400')
        {
            echo $income+=(3400/100)*25; echo "<hr>";
        }
        else if($row_earn['cb_package']=='Advance Details Rupees 6100')
        {
            echo $income+=(6100/100)*25; echo "<hr>";
        }
        //--------------------------//Level 2-------------------------
        $sql_earn1="SELECT * FROM jos_comprofiler where cb_parentid='".$row_earn['user_id']."'";
        $result_earn1 = mysql_query($sql_earn1);
        while($row_earn1 = mysql_fetch_array($result_earn1))
        {
            if($row_earn1['cb_package']=='Basic Details Rupees 3400')
            {
                echo $income+=(3400/100)*25; echo "<hr>";
            }
            else if($row_earn1['cb_package']=='Advance Details Rupees 6100')
            {
                echo $income+=(6100/100)*25; echo "<hr>";
            }
        }
        //--------------------------//Level 2-------------------------
    }
    echo $income;
}

here we mention

<div><?php echo "Earning: ".earning($row0->user_id); ?></div>