Forum >
Threads >
Articles');
print('
');
print(' ');
print('Author | ');
print('Title | ');
print('
');
include("db.inc");
$db=db_connect();
$id=$HTTP_GET_VARS['id'];
$user=$HTTP_GET_VARS['user'];
$anfrage="SELECT * FROM articles WHERE a_id=".$id;
$ergebnis=db_query($anfrage);
$anz=mysql_num_rows($ergebnis);
mysql_data_seek($ergebnis,$a);
$zeile=mysql_fetch_row($ergebnis);
print('');
print('');
print($zeile[5]);
print(' | ');
print('');
print($zeile[4]);
print('
Written at: ');
print($zeile[6]);
if($zeile[2]>0){
print(' This is an answere of previous article');
}
print('
');
print($zeile[3]);
print(' | ');
print('
');
print('');
print('new article');
print(' | ');
print('replay to this');
print(' | ');
print('
');
print('');
print('
');
$anfrage2="SELECT * FROM articles WHERE reof_id=".$id." ORDER BY time_p DESC";
$ergebnis2=db_query($anfrage2);
$anz2=mysql_num_rows($ergebnis2);
if($anz2>0) {
print('This article has '.$anz2.' answers:');
for($a=$anz2-1;$a>-1;$a--) {
$zeile2=mysql_fetch_row($ergebnis2);
print('
');
print($zeile2[4]);
print('');
}
}
db_close($db);
?>