$sid = '166410';

        $query =  "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 = '';
   mysqli_stmt_bind_param($st, "s", $sid);
    if ($st = mysqli_prepare($link, $query)) {

        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>
                  ";
                } $st->free();
            mysqli_stmt_close($st);
        }

        print($mysqli_num_rows());
        mysqli_close($link);

        print($scap);