Mam coś takiego
Kod
function waznewiad() {
global $news_tbl, $theme, $icon;
$query = "SELECT * FROM $news_tbl WHERE stat <> '2' AND topic = '30' ORDER BY date DESC LIMIT 10";
$res = mysql_query($query);
$x=0;
$limit['text_litery'] = 300; // dopuszczalna ilosc liter
$limit['title_litery'] = 32; // dopuszczalna ilosc liter
while($r=mysql_fetch_array($res))
{
$data[] = $r;
$x++;
}
$r1=$r2=0;
do
{
$r1 =rand(0,$x-1);
$r2 =rand(0,$x-1);
}while($r1 == $r2);
foreach($data as $key => $row)
{
if($key != $r1 && $key != $r2) continue;
$icon = $row['icon'];
$row['text'] = substr ($row['text'], 0, $limit['text_litery']); // obcinanie
$row['title'] = substr ($row['title'], 0, $limit['title_litery']); // obcinanie
if($icon=='') $icon = ' '; else $icon = '<div class="img1"><a title="'.$row['title'].'" href="news.php?id='.$row['id'].'"><img src="'.$icon.'" height="60" width="60" border="0" ></a></div>';
$komenty=($row['comments']<>0)?'<img src="images/img_comment.png"> <A href="comment.php?what=news&id='.$row['id'].'">Wasze komentarze ('.$row['comments'].')</a>':'<img src="images/img_comment.png"> <A href="comment.php?what=news&id='.$row['id'].'">Wasze komentarze ('.$row['comments'].')</a>';
$row['text']=make_clickable($row['text']);
echo '
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="390" style="padding-bottom: 5px;" class="block" valign="top">
'.$icon.'
<A class="box_wazne" title="'.$row['title'].'..." href="news.php?id='.$row['id'].'"><b>'.stripslashes($row['title']).'...</b></A>
<div class="tytul_lewa"></div>
<A class="box1" title="'.$row['title'].'..." href="news.php?id='.$row['id'].'">'.stripslashes($row['text']).'... <SPAN class="arr1">»</SPAN></A><br>
</td>
</tr>
</table>
';
}
}
global $news_tbl, $theme, $icon;
$query = "SELECT * FROM $news_tbl WHERE stat <> '2' AND topic = '30' ORDER BY date DESC LIMIT 10";
$res = mysql_query($query);
$x=0;
$limit['text_litery'] = 300; // dopuszczalna ilosc liter
$limit['title_litery'] = 32; // dopuszczalna ilosc liter
while($r=mysql_fetch_array($res))
{
$data[] = $r;
$x++;
}
$r1=$r2=0;
do
{
$r1 =rand(0,$x-1);
$r2 =rand(0,$x-1);
}while($r1 == $r2);
foreach($data as $key => $row)
{
if($key != $r1 && $key != $r2) continue;
$icon = $row['icon'];
$row['text'] = substr ($row['text'], 0, $limit['text_litery']); // obcinanie
$row['title'] = substr ($row['title'], 0, $limit['title_litery']); // obcinanie
if($icon=='') $icon = ' '; else $icon = '<div class="img1"><a title="'.$row['title'].'" href="news.php?id='.$row['id'].'"><img src="'.$icon.'" height="60" width="60" border="0" ></a></div>';
$komenty=($row['comments']<>0)?'<img src="images/img_comment.png"> <A href="comment.php?what=news&id='.$row['id'].'">Wasze komentarze ('.$row['comments'].')</a>':'<img src="images/img_comment.png"> <A href="comment.php?what=news&id='.$row['id'].'">Wasze komentarze ('.$row['comments'].')</a>';
$row['text']=make_clickable($row['text']);
echo '
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="390" style="padding-bottom: 5px;" class="block" valign="top">
'.$icon.'
<A class="box_wazne" title="'.$row['title'].'..." href="news.php?id='.$row['id'].'"><b>'.stripslashes($row['title']).'...</b></A>
<div class="tytul_lewa"></div>
<A class="box1" title="'.$row['title'].'..." href="news.php?id='.$row['id'].'">'.stripslashes($row['text']).'... <SPAN class="arr1">»</SPAN></A><br>
</td>
</tr>
</table>
';
}
}
i dzięki temu wyświetla mi na stronie 2 newsy z 10 ostatnio dodanych i teraz chcem żeby te rotacyjnie 2 newsy były losowane co 5 sekund bez odświeżania strony.
Proszę o pomoc!