All pastes #424171 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-04-04 16:48 UTC
rendered paste body
<?php
require("includes/defaultmysqlconfig.php");
require("includes/mysqlconnect.php");
echo("<div style=\"text-align: center;\">");
echo("<b>News prelevate dalle varie aree del sito:</b><br /><br /");
echo("<b>Ultimi post nel forum:</b>");

$query = "SELECT * FROM smf_messages WHERE ID_MSG='*' ORDER BY ID_MSG DESC LIMIT 5";
$result = mysql_query($query);

if (mysql_num_rows($result)!=0) {
  while($riga=mysql_fetch_array($result)) { 

   $query_oggetto = "SELECT * FROM smf_messages WHERE ID_MSG='*'";
   $result_oggetto = mysql_query($query_oggetto);
   $riga_oggetto = mysql_fetch_array($result_oggetto);
   $oggetto_post = $riga_oggetto['subject'];

   
   $query_autore = "SELECT * FROM smf_messages ID_MSG='*'";
   $result_autore = mysql_query($query_autore);
   $riga_autore = mysql_fetch_array($result_autore); 
   $autore_post = $riga_autore['posterName'];
   
   
   $query_data = "SELECT * FROM smf_messages ID_MSG='*'";
   $result_data = mysql_query($query_data);
   $riga_data = mysql_fetch_array($result_data);
	$data_post = $riga_data['posterTime']; 
		
	echo("<li>" . $oggetto_post . " (inserito il" . $data_post . " da <b>" . $autore_post . "</b>)</li>");
}
}
?>