list(,$_timestamp) = get_item_with_args("");
// Pour l'accès à la base de donnée
require("php/db_config.php");
mysql_connect($conf["host"],$conf["user"],$conf["passwd"]);
$query = "select name, email, DATE_FORMAT(datetime_creation,'le %d/%m/%Y à %H:%i:%s') date, UNIX_TIMESTAMP(datetime_creation) timestamp, title, comment, category from blog ";
if ($_timestamp) {
$query .= " where UNIX_TIMESTAMP(datetime_creation)=".$_timestamp." ";
}
$query .= "order by datetime_creation desc";
$is_ok=1;
$result = mysql_db_query($conf["db"],$query)
or $is_ok=0;
if($is_ok){
while($row = mysql_fetch_array($result)){
$date = $row["date"];
$timestamp = $row["timestamp"];
$name = $row["name"];
$email = $row["email"];
$title = $row["title"];
$comment = $row["comment"];
$category = $row["category"];
if ($category == "") $category = "default";
echo "
";
echo "
\n";
echo "$title - $name, ";
echo htmlentities($date);
echo "
\n";
echo "\n";
echo "
";
}
} else {
echo "Mon blog est malheureusement indisponible.";
}
?>
Date de derni�re modification :20/03/2006