
01-06-2006, 08:45 AM
|
|
|
Join Date: Apr 2005
Location: Belgium
Posts: 341
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
@kadafi_alive:
To fix the last updates
find:
Quote:
$lasteditedresults=$db->query_read("
SELECT t1.userid, t2.username, t1.dateline FROM
".TABLE_PREFIX."userpage AS t1
LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid)
ORDER BY t1.views DESC LIMIT 0,5");
|
and replace with:
Quote:
$lasteditedresults=$db->query_read("
SELECT t1.userid, t2.username, t1.dateline FROM
".TABLE_PREFIX."userpage AS t1
LEFT JOIN ".TABLE_PREFIX."user AS t2 ON(t1.userid=t2.userid)
ORDER BY t1.dateline DESC LIMIT 0,5");
|
|