$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 = '';

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

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

        print($scap);