PHP code

$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"
                                );
              mysqli_stmt_bind_param($query, "s", $sid);
              mysqli_stmt_execute($query);
              mysqli_stmt_bind_result($query, $ayr, $status, $ptitle, $lvl);
              mysqli_stmt_fetch($query);
              mysqli_stmt_close($query);

    $scap = '';
    if($result = $link->query($query)) {
            while ($row = $result->fetch_assoc()) {
                $scap .= "
                        <table id=\"test\" style=\"width:100%\">
                            <tr>
                                <td> " . $ayr . " </td>
                                <td> " . $status . "</td>
                                <td> " . $ptitle . "</td>
                                <td> " . $lvl . "</td>
                            </tr>
                        </table>
                    ";
                }
            $result->free();
        }