Forum

-1;$a--) { mysql_data_seek($ergebnis,$a); $zeile=mysql_fetch_row($ergebnis); print(''); print(''); $anfrage1="SELECT * FROM articles WHERE th_id=".$zeile[0]." AND reof_id='0' ORDER BY time_p DESC"; $ergebnis1=db_query($anfrage1); $anz1=mysql_num_rows($ergebnis1); $zeile1=mysql_fetch_row($ergebnis1); print(''); print(''); $anfrage2="SELECT * FROM articles WHERE th_id=".$zeile[0]." AND reof_id=".$zeile1[0]." ORDER BY time_p DESC"; $ergebnis2=db_query($anfrage2); $anz2=mysql_num_rows($ergebnis2); $zeile2=mysql_fetch_row($ergebnis2); print(''); print(''); print(''); } if($anz1==0){ print(''); } } print('

Threads	Number of articles	Last article	Number of replays	Last replay
'); print($zeile[1]); print('	'); print($anz1); print('	'); if($anz1==0) { print('-'); } else { print(''); print($zeile1[4]); print('	'); print($anz2); print('	'); if($anz2==0) { print('-'); } else { print(''); print($zeile2[4]); } print('
-	-

'); db_close($db); ?>