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.