Просмотр поста

<script>
        $(document).ready(function () {
            $("button#users").on('click', function () {
                event.preventDefault();
                $.ajax({
                    type: "POST",
                    url: "ajax.php",
                    dataType: "json",
                    data: ({
                        test: "ok"
                    }),
                    success: function (data) {
                        var len = data.length;
                        for (var cnt = 0; cnt < len; cnt++) {
                            $('#list').append('<p><span style="margin-left: 5px;">' + data[cnt].id + '</span>' +
                                '<span style="margin-left: 5px;">' + data[cnt].name + '</span>' +
                                '<span style="margin-left: 5px;">' + data[cnt].sex + '</span>' +
                                '<span style="margin-left: 5px;">' + data[cnt].lastdate + '</span>' +
                                '<span style="margin-left: 5px;">' + data[cnt].status + '</span>' +
                                '<span style="margin-left: 5px;">' + data[cnt].rights + '</span>' +
                                '</p>');
                        }
                    }
                });
            });
        });
    </script>

$test = isset($_POST['test']) ? trim($_POST['test']) : '';
if($test == 'ok'){
    $req = mysql_query("SELECT `id`, `name`, `sex`, `lastdate`, `datereg`, `status`, `rights` FROM `users` ORDER BY `id` DESC LIMIT 0, 9");
    $rows = array();
    while ($res = mysql_fetch_array($req))
        $rows[] = $res;
    exit(json_encode($rows));
}