//recuperation du valeur aléatoirement

$result=mysql_query("SELECT id,file,cat_id FROM $prefixeTable"."images order by rand();");
$result=mysql_fetch_array($result);

// recuperation de la categorie de l'image
$result2=mysql_query("SELECT id,id_uppercat,dir FROM $prefixeTable"."categories WHERE id='".$result['cat_id']."' ");
$result2=mysql_fetch_array($result2);

if ($result2['id_uppercat']){
  $result3=mysql_query("SELECT id,dir FROM $prefixeTable"."categories WHERE id='".$result2['id_uppercat']."' ");
  $result3=mysql_fetch_array($result3);
  $image="./galleries/".$result3['dir']."/".$result2['dir']."/thumbnail/TN_".$result['file']."";
  $expend=$result3['id'];
}else{
  $image="./galleries/".$result2['dir']."/thumbnail/TN_".$result['file']."";
  $expend=$result2['id'];
}

// calcul de la valeur pour num
$num=0;
$number=mysql_query("SELECT file,date_available FROM $prefixeTable"."images WHERE cat_id='".$result['cat_id']."' order by date_available desc");
while  ( $rang = mysql_fetch_array($number) ){
  if ( $rang['file'] == $result['file'] ) $num_final = $num;
  $num++;
}

// lien + image aleatoire

$output.="<a href='".add_session_id_to_url("./photo.php?cat=".$result2['id']."&num=".$num_final."&expand=".$expend."")."'><img border=0 src=".$image."></img></a></center><br />";