requete('SELECT * FROM saison WHERE sais_num='.$_GET['sais_num']); //$data_date=mysql_fetch_array($connection_date->result); //--------------------------------------------------------------------------------------------------------- // Verification de la variable $index_to_return permettant de savoir si l'on a deja consulter des pages de sujet //--------------------------------------------------------------------------------------------------------- if(empty($_GET['page'])) { $index_to_return=0; } else { $index_to_return=($_GET['page']-1)*10; } //$connection_compt->requete('SELECT * FROM rateaux WHERE rat_sais='.$_GET['sais_num'].' AND rat_valide=1'); $connection_compt->requete('SELECT * FROM old_rateaux WHERE rat_valide=1'); $nb_pages=mysql_num_rows($connection_compt->result); $nb_pages=$nb_pages/10; // $connection_rat->requete('SELECT DISTINCT rat_sexe,rat_aut,rat_date,rat_score,rat_desc,champ_nom,rat_type_type FROM championnat,rateaux,rat_type,type WHERE rat_champ=champ_num AND rat_num=rat_type_rat AND rat_valide=1 AND rat_sais='.$_GET['sais_num'].' ORDER BY rat_score DESC LIMIT '.$index_to_return.',10'); $connection_rat->requete('SELECT DISTINCT rat_sexe,rat_aut,rat_date,rat_score,rat_desc,champ_nom,rat_type_type,sais_nom FROM old_championnat,old_rateaux,old_rat_type,old_type,old_saison WHERE rat_champ=champ_num AND rat_sais=sais_num AND rat_num=rat_type_rat AND rat_valide=1 ORDER BY rat_score DESC LIMIT '.$index_to_return.',10'); ?> Le site de la Fédération française de Râteaux

Tous les râteaux

Voici les râteaux affichés par 10 et classés par ordre de score décroissant.

result)) { if($data_rat['rat_sexe']=='M') { $bgScolor='#D7ECF7'; } else { $bgScolor='#F4EBF8'; } if(!empty($data_rat['rat_type_type'])) { $type=explode(',',$data_rat['rat_type_type']); $typeliste=''; foreach($type as $type) { $connection_type->requete('SELECT type_nom FROM old_type Where type_num='.$type); $data_type=mysql_fetch_array($connection_type->result); $typeliste=$typeliste.$data_type['type_nom'].','; } $typeliste=trim($typeliste,','); } else { $typeliste='Aucune'; } echo ''; } echo'
'.$data_rat['rat_aut'].' '.$data_rat['champ_nom'].'
'.$data_rat['sais_nom'].'
'.$data_rat['rat_date'].' '.$typeliste.' '.$data_rat['rat_score'].'
'.nl2br($data_rat['rat_desc']).'

Pages : '; $compt=0; while($nb_pages>0) { $compt=$compt+1; //echo '|'.$compt.'| '; echo ''.$compt.' '; $nb_pages=$nb_pages-1; if ($nb_pages>0) { echo ' - ';} } echo'
'; ?>