Suleiman
Хочу сделать сортировку чтоб из БД по годам выводилась публикации, что тут не так?
Структура БД. id, yers, name_g, img_g, text_gazeta, name_j,img_j, text_jurnal
[php:1:b3321b4bb2]<?php
if(!empty($row['yers'])){
$interv = $mysqli->query("SELECT * FROM interviyu ORDER BY id ASC");
while ($row = $interv->fetch_assoc()) {
echo '<table width="660" height="66" cellpadding="2">
<tr>
<th width="497" height="56" align="left" valign="top" scope="row"><p><a href="../news/content.php?id='.$row['id'].'">'.$row['name_g'].''.$row['name_j'].'</a></p></th>';
if(!empty($row['img'])){ echo'<td width="89"><a href="../news/content.php?id='.$row['id'].'"><img class="img" src="'.$row['img'].'" width="112" border="0" height="69"></a></tr>';}
echo '</table><div class ="ftext"></div>';
} }?>
<?php
if(!empty($row['yers'])){
$interv = $mysqli->query("SELECT * FROM interviyu ORDER BY id ASC");
while ($row = $interv->fetch_assoc()) {
echo '<table width="660" height="66" cellpadding="2">
<tr>
<th width="497" height="56" align="left" valign="top" scope="row"><p><a href="../news/content.php?id='.$row['id'].'">'.$row['name_g'].''.$row['name_j'].'</a></p></th>';
if(!empty($row['img'])){ echo'<td width="89"><a href="../news/content.php?id='.$row['id'].'"><img class="img" src="'.$row['img'].'" width="112" border="0" height="69"></a></tr>';}
echo '</table><div class ="ftext"></div>';
} }?>[/php:1:b3321b4bb2]