$host = "localhost";
$login = "your_login";
$pass = "your_pass";
$base = "your_zenith_base";


$connect = mysql_connect($host,$login,$pass);
mysql_select_db($base, $connect);
       $sql = "SELECT pid,title, approved, counter FROM zenith_pictures WHERE approved=1 ORDER BY date DESC LIMIT 30";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());



while($data = mysql_fetch_array($req))

{

echo '<a href="pic_details.php?pid='.$data['pid'].'">';

echo '<b>'.stripslashes($data['title']).'</a</b></br>';

}

<?php
//colonne de droite - 30 derniers ajouts      


$connect = mysql_connect($sql_host,$sql_user,$sql_pass);
mysql_select_db($dbname, $connect);
       $sql = "SELECT pid,title,date, approved, description, counter FROM zenith_pictures WHERE approved=1 ORDER BY date DESC LIMIT 30";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$hier='0';


while($data = mysql_fetch_array($req))

{
   $Date = $data['date'];
   $time = substr ("$Date", -5);
   $rest = substr ("$Date", 0, 10);
   list ($year, $month, $day) = split ("-", $rest);
   $ajd = ("$day"."/"."$month"."/"."$year");

if ($hier != $ajd)
     {     print "<br><b><u>$ajd : </u></b><br>";
     }
echo '<a href="pic_details.php?pid='.$data['pid'].'">';

echo '<b>'.stripslashes($data['title']).'</a> <font color=#CC0033>('.stripslashes(nl2br($data['description'])).')</b></font><br>';
$hier=$ajd;
}

?>

echo     "<td width='374' height='237' bgcolor='#FFFFCC' align='center'><br><b><u>the last 30 additions </u> :</b><br><br><br>";
echo "<marquee direction='up' scrollamount='2' height='200' width=200 onmouseover='this.stop()' onmouseout='this.start()'>";

require('list.php');

echo "</marquee>";

echo        "<br></td>";