query = mysqli_prepare($link, "SELECT enrl.ayr, enrl.status, prog.ptitle, enrl.lvl
                                        FROM enrl, prog
                                        WHERE enrl.sid =?
                                        AND enrl.pid = prog.pid
                                        ORDER BY lvl DESC"
                                  );
    $scap = '';
    if ($st = mysqli_prepare($link, $query)) {
        mysqli_stmt_bind_param($st, "s", $sid);
        mysqli_stmt_execute($st);
        mysqli_stmt_bind_result($st, $ayr, $status, $ptitle, $lvl);

            while (mysqli_stmt_fetch($st)) {
                $scap .= "
                        <table id=\"test\" style=\"width:100%\">
                            <tr>
                                <td> " . $ayr . " </td>
                                <td> " . $status . "</td>
                                <td> " . $ptitle . "</td>
                                <td> " . $lvl . "</td>
                            </tr>
                        </table>
                    ";
                }
            $result->free();
            mysqli_stmt_close($st);
        }