Can't show last topics on homepage

Последняя активность
Файлы топика
347
.
RZYV_login
25 мая 2016 г., 23:11
Hello, i need this modules. I want to see last themes on homepage. I write code, but dont work. When i delete `type`='t' from code, this work. But, i see all themese, categorys and so on. Please, help me.
.
blackvj
25 мая 2016 г., 23:27
Изменено
U must add 
Order by `time` Limit 10;

into your SQL
.
RZYV_login
25 мая 2016 г., 23:31 
$limit = '5';
$req_t = mysql_query("SELECT `id`, `text` FROM `forum` WHERE `type`='t' ORDER BY `time` DESC LIMIT $limit ");
while($res_t = mysql_fetch_array($req_t))
{
echo '<p><a href="forum/?id='.$res_t['id'].'"><span style="color:#FFA500"><b>Forumda son mövzu: '.$res_t['text'].'</b></span></a></p>';
}


is it correct code?
.
blackvj
25 мая 2016 г., 23:52
RZYV_login, yes
.
RZYV_login
25 мая 2016 г., 23:54
But, not working
.
RZYV_login
25 мая 2016 г., 23:56
When i write this code, i dont see anything. I think this is localhost problem.
.
blackvj
25 мая 2016 г., 23:59
RZYV_login, yes, problem on your side, because i cheked your code and it work normal.
.
RZYV_login
26 мая 2016 г., 0:00
Thanks for all
.
reaper
26 мая 2016 г., 0:01
I've renamed this topic. Choose a correct name for topics next time please.
.
RZYV_login
26 мая 2016 г., 0:04
reaper, Okay. Sorry.
Всего: 11
© 2024, JohnCMS