FIRST $reqSELECTartistCure = "SELECT * FROM artists WHERE id_artist=1"; $rsSELECTartistCure = mysql_query ( $reqSELECTartistCure ); //Autres ensuite $reqSELECTartistNOCure = "SELECT DISTINCT artist, id_artist FROM artists WHERE id_artist!=1 ORDER BY artist"; $rsSELECTartistNOCure = mysql_query ( $reqSELECTartistNOCure ); // Tribute (id_artist = 1000) -----> LAST $reqSELECTartistTribute = "SELECT * FROM artists WHERE id_artist=1000"; $rsSELECTartistTribute = mysql_query ( $reqSELECTartistTribute ); //................................................................................................................................................................................................................................................ $reqSELECTsupport = "SELECT DISTINCT support_type FROM official_records ORDER BY support_type"; $rsSELECTsupport = mysql_query ( $reqSELECTsupport ); //................................................................................................................................................................................................................................................ $reqSELECTpays = "SELECT DISTINCT pays FROM official_records ORDER BY pays"; $rsSELECTpays = mysql_query ( $reqSELECTpays ); //................................................................................................................................................................................................................................................ // Cure (id_artist = 1) -----> FIRST $reqSELECTtitreCure = "SELECT DISTINCT titre_disque FROM official_records WHERE id_artist = 1 ORDER BY titre_disque"; $rsSELECTtitreCure = mysql_query ( $reqSELECTtitreCure ); //Autres ensuite $reqSELECTtitreNOCure = "SELECT DISTINCT R.titre_disque, A.artist FROM official_records R, artists A WHERE R.id_artist = A.id_artist AND R.id_artist != 1 ORDER BY titre_disque"; $rsSELECTtitreNOCure = mysql_query ( $reqSELECTtitreNOCure ); //................................................................................................................................................................................................................................................ //................................................................................................................................................................................................................................................ ?>

Artist : all... selected ".$a[artist].""; } ?> ............................................... selected ".$aa[artist].""; } ?> ............................................... selected ".$aaa[artist].""; } ?> Format : all... selected ".$s[support_type].""; } ?> From : all... selected ".$p[pays].""; } ?> Title : all... selected ".$t[titre_disque].""; } ?> .............................................................................................. selected ".$tt[titre_disque]." (".$tt[artist].")"; } ?> ............................................... selected All Cure related & Collaborations..."; ?> >Only all the NEW ones. Order by : checked> format checked> from checked> title checked>

Images reproduced with kind permission of www.thecurerecords.com

"; } else { echo "".$nbDisquesTrouves." Records found."; echo "

"; //===========================AFFICHAGE==============================================// while ( ($r = mysql_fetch_array( $rsSELECT ) ) != NULL ) { echo ""; $num = $no++; if ( strlen($num) == 1 ) { $num = "00".$num; } else if ( strlen($num) == 2 ) { $num = "0".$num; } // --> http://www.thecurerecords.com/ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ( $withPic == 1 && $r[img_thecurerecords] != NULL && $r[id_thecurerecords] != NULL ) { echo ""; } elseif ( $withPic == 1 && $r[img_thecurerecords] == NULL && $r[id_thecurerecords] != NULL ) { echo ""; } else { echo ""; } echo ""; } } ?>

".$num.".

".$r[support_type]." ".$r[support_detail]."

".$r[pays]."

".$r[ref]."

".$r[titres]; if ( $r[id_artist] != 1 || ( $r[titre_compil] != '' && $r[titre_compil] != NULL ) ) { echo "   --> "; } if ( $r[id_artist] != 1 ) { echo $r[artist]." "; } if ( $r[titre_compil] != '' && $r[titre_compil] != NULL ) { echo "\"".$r[titre_compil]."\""; } if ( $r[year] != '' && $r[year] != NULL ) { echo "   --> ".$r[year]; } echo "

".$r[description]."

"; echo "

"; echo "(...)

10 ) { echo "

"; } ?>