-- ----------------------------
DROP TABLE IF EXISTS `uye_mesaj`;
CREATE TABLE `uye_mesaj` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gonderen_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL,
  `gonderen_isim` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL,
  `baslik` varchar(255) DEFAULT NULL,
  `konu` varchar(255) NOT NULL,
  `icerik` varchar(255) NOT NULL,
  `alan_token` varchar(255) NOT NULL,
  `alan_isim` varchar(255) NOT NULL DEFAULT '',
  `g_tarih` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_sifre` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin5;

<?php




$token1 = $_SESSION['token'];
$sorgu = $db->prepare("SELECT *  FROM uye_mesaj  WHERE alan_token = :gonderen_token Order By g_tarih  DESC  ");
$sorgu->bindParam(':gonderen_token', $token1);

$sorgu->execute();
$toplam = $sorgu->rowCount();
while ($cikti = $sorgu->fetch(PDO::FETCH_ASSOC)) {
$mid=$cikti["id_sifre"];
$icerikb=$cikti["icerik"];
$mesajoku="<a href='/mesajoku.php?id=$mid'> <button type='button' class='btn btn-primary waves-effect waves-light btn-rounded'>Mesajı Oku Veya Yanıt Ver</button> </a>";
echo "<tr><td>" . $toplam. "</td> <td>" . $cikti["gonderen_isim"] . "</td> <td>" . $cikti["baslik"] . "</td> <td>" . $cikti["konu"]."</td> <td>" .$cikti["g_tarih"]."</td> <td>"
.$mesajoku. "</td> </tr>"  ;}?>