Помощь по скриптам | Помощь с sql
Как сделать чтоб написаны сообщения на форуме были в начале темы а не в конце?
HostISP, при выводе добавь в запрос DESC LIMIT
Сортируй с помощью DESC
while($a = mysql_fetch_assoc($post)){
echo '<table class="menu" cellspacing="0" cellpadding="0">';
echo '<td class="block_avatar">';
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$a['us']."'"));
echo (empty($ank['avatar'])?'<img class="avatar" src="/files/ava/net.png">':'<img class="avatar" src="/files/ava/'.$ank['avatar'].'">');
echo '</td>';
echo '<td class="block_content">';
echo ''.nick($a['us']).' ';
echo '<span class="time">'.vremja($a['time']).'</span>';
if($user['id'] == $a['us'] or $user['level'] >= 1) echo '<span style="float:right;"><a href="/forum/post_red'.$a['id'].'"><span class="ficon"><i class="fas fa-ellipsis-h"></i></span></a></span>';
if(!$a['citata'] == NULL) echo '<div class="cit">'.nick($a['citata_us']).': '.nl2br(smile(bb($a['citata']))).'</div>';
echo '<div class="block_msg">'.nl2br(smile(bb($a['text']))).'</div>';
echo '<span style="float:right;margin: 12px 0px 0px 0px;">';
if($user['id'] != $a['us']) echo ' <a href="/forum/post_otvet'.$a['id'].'" title="Ответить"><span class="ficon"><i class="fas fa-reply"></i></span></a> ';
if($user['id'] != $a['us']) echo ' <a href="/forum/post_citata'.$a['id'].'" title="Ответить, цитируя это сообщение"><span class="ficon"><i class="far fa-comment-alt"></i></span></a> ';
if($user['level'] >= 2) echo ' <a href="/forum/post_del'.$a['id'].'" title="Удалить сообщение"><span class="ficon"><i class="fas fa-times"></i></span></a> ';
echo '</span>';
$count = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `forum_file` WHERE `post_id` = '".$a['id']."'"),0);
if($count) {
$load_s = mysql_query("SELECT * FROM `forum_file` WHERE `post_id`='".$a['id']."'");
while($a = mysql_fetch_array($load_s)){
echo '<div class="block_msg"><a style="color:#1ea96d;" href="../files/forum/'.$a['name_file'].'"><span class="icon"><i class="fab fa-cloudversify"></i></span> '.$a['name_file'].'</a> <span class="time">'.fsize('../files/forum/'.$a['name_file']).'</span></div>';
}
}
echo '</td>';
echo '</table>';
}
Нихрена не пойму
echo '<table class="menu" cellspacing="0" cellpadding="0">';
echo '<td class="block_avatar">';
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$a['us']."'"));
echo (empty($ank['avatar'])?'<img class="avatar" src="/files/ava/net.png">':'<img class="avatar" src="/files/ava/'.$ank['avatar'].'">');
echo '</td>';
echo '<td class="block_content">';
echo ''.nick($a['us']).' ';
echo '<span class="time">'.vremja($a['time']).'</span>';
if($user['id'] == $a['us'] or $user['level'] >= 1) echo '<span style="float:right;"><a href="/forum/post_red'.$a['id'].'"><span class="ficon"><i class="fas fa-ellipsis-h"></i></span></a></span>';
if(!$a['citata'] == NULL) echo '<div class="cit">'.nick($a['citata_us']).': '.nl2br(smile(bb($a['citata']))).'</div>';
echo '<div class="block_msg">'.nl2br(smile(bb($a['text']))).'</div>';
echo '<span style="float:right;margin: 12px 0px 0px 0px;">';
if($user['id'] != $a['us']) echo ' <a href="/forum/post_otvet'.$a['id'].'" title="Ответить"><span class="ficon"><i class="fas fa-reply"></i></span></a> ';
if($user['id'] != $a['us']) echo ' <a href="/forum/post_citata'.$a['id'].'" title="Ответить, цитируя это сообщение"><span class="ficon"><i class="far fa-comment-alt"></i></span></a> ';
if($user['level'] >= 2) echo ' <a href="/forum/post_del'.$a['id'].'" title="Удалить сообщение"><span class="ficon"><i class="fas fa-times"></i></span></a> ';
echo '</span>';
$count = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `forum_file` WHERE `post_id` = '".$a['id']."'"),0);
if($count) {
$load_s = mysql_query("SELECT * FROM `forum_file` WHERE `post_id`='".$a['id']."'");
while($a = mysql_fetch_array($load_s)){
echo '<div class="block_msg"><a style="color:#1ea96d;" href="../files/forum/'.$a['name_file'].'"><span class="icon"><i class="fab fa-cloudversify"></i></span> '.$a['name_file'].'</a> <span class="time">'.fsize('../files/forum/'.$a['name_file']).'</span></div>';
}
}
echo '</td>';
echo '</table>';
}
Нихрена не пойму
$post= mysql_query('SELECT * FROM `chat` ORDER BY `id` DESC LIMIT 10 ');
while($a = mysql_fetch_assoc($post)){
________
посл. ред. 13.01.2021 в 13:17; всего 1 раз(а); by [Удален]
while($a = mysql_fetch_assoc($post)){
________
посл. ред. 13.01.2021 в 13:17; всего 1 раз(а); by [Удален]