resulalagozoglu adlı üyeden alıntı: mesajı görüntüle
Buyrun hocam
Kullanıcı adı verisi user Tablosunda kadi olarak kayıtlı

<div class="card card-style">
<div class="content mt-2 mx-2 px-1 pt-1">
<div class="d-flex">
<center>
<h4 class="font-14 mb-n1 ps-3">Teklif Duvarından Kazanan Son 25 Kişi</h4>
</center>
</div>
<div class="card overflow-visible card-style">
<div class="content mb-0">
<div class="table-responsive">
<table class="table color-theme mb-2">
<thead>
<th>Miktar</th>
<th>ID</th>
<th>Duvar</th>
</thead>
<tbody>
<?php
$pbirims = @mysqli_query($baglanti, "select * from ayarlar where id = '1'");
$pbirimss = mysqli_fetch_array($pbirims);
if ($pbirimss["pbirim"]=='1') {
$pbirim = 'TL';
}elseif ($pbirimss["pbirim"]=='2') {
$pbirim = 'Puan';
}
$SAYI = 1; $AC_ID=$_SESSION["id"];
$CONNECT_RANK = mysqli_query($baglanti,"SELECT * FROM postbacks ORDER BY id DESC LIMIT 25");
while ($VIEW_RANK = mysqli_fetch_array($CONNECT_RANK)) {
echo '
<tr>
<td>'.$VIEW_RANK["rewards"].' '.$pbirim.'</td>
<td>'.$VIEW_RANK["user_id"].' </td>
<td>'.$VIEW_RANK["offerwall"].' </td>

</tr>

';
$SAYI++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
<div class="card card-style">
    <div class="content mt-2 mx-2 px-1 pt-1">
        <div class="d-flex">
            <center>
                <h4 class="font-14 mb-n1 ps-3">Teklif Duvarından Kazanan Son 25 Kişi</h4>
            </center>
        </div>
        <div class="card overflow-visible card-style">
            <div class="content mb-0">
                <div class="table-responsive">
                    <table class="table color-theme mb-2">
                        <thead>
                            <th>Miktar</th>
                            <th>Kullanıcı Adı</th>
                            <th>Duvar</th>
                        </thead>
                        <tbody>
                            <?php                         
                            $pbirims = @mysqli_query($baglanti, "SELECT * FROM ayarlar WHERE id = '1'");
                            $pbirimss = mysqli_fetch_array($pbirims);
                            if ($pbirimss["pbirim"] == '1') {
                                $pbirim = 'TL';
                            } elseif ($pbirimss["pbirim"] == '2') {
                                $pbirim = 'Puan';
                            }

                            // postbacks ve user tablolarını birleştirerek verileri alın
                            $CONNECT_RANK = mysqli_query($baglanti, "
                                SELECT p.rewards, u.username, p.offerwall
                                FROM postbacks p
                                JOIN user u ON p.user_id = u.id
                                ORDER BY p.id DESC
                                LIMIT 25
                            ");
                            while ($VIEW_RANK = mysqli_fetch_array($CONNECT_RANK)) {
                                echo '
                                <tr>
                                    <td>'.htmlspecialchars($VIEW_RANK["rewards"]).' '.htmlspecialchars($pbirim).'</td>
                                    <td>'.htmlspecialchars($VIEW_RANK["username"]).'</td>
                                    <td>'.htmlspecialchars($VIEW_RANK["offerwall"]).'</td>
                                </tr>';
                            }
                            ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
Bunun işe yaraması lazım hocam doğru anladıysam eğer.