 |
| |
Discographie |
| |
$i = 0;
$ref_tri = "ref_year";
$ref_tri2 = "ref_month";
$ref_tri3 = "ref_id";
$find_ref = mysql_query("SELECT * FROM `reference` WHERE ref_link_profil = 10 AND ref_pub = 1 ORDER by $ref_tri DESC,$ref_tri2 DESC,$ref_tri3 DESC") or die("Problem SUR SQL2 TESTING");
while ($print_ref = mysql_fetch_array($find_ref))
{
$ref_id = $print_ref["ref_id"];
$ref_pub = $print_ref["ref_pub"];
$ref_link_profil = $print_ref["ref_link_profil"];
$ref_link_artist = $print_ref["ref_link_artist"];
$ref_img = $print_ref["ref_img"];
$ref_year = $print_ref["ref_year"];
$ref_month = $print_ref["ref_month"];
$ref_titre_fr = $print_ref["ref_titre_fr"];
$ref_label = $print_ref["ref_label"];
$ref_desc_fr = $print_ref["ref_desc_fr"];
$recup_artist = mysql_query ("SELECT * FROM `artist` WHERE art_id ='$ref_link_artist'") or die("Can't Perform Query lang1");
while ($link_artist = mysql_fetch_array($recup_artist))
{
$link_art_id = $link_artist["art_id"];
$link_art_name = $link_artist["art_name"];
}
if ($ref_link_artist = $link_art_id ) { $ref_artist = $link_art_name ;}
if ($ref_img == '') {$ref_img_back = " ";}
else {$ref_img_back = " ";}
echo "
"
;
$i++;
}
mysql_free_result($find_ref);
?> |
| |
|
|
 |
| |
Mes news |
 |
| |
echo $pro_actu_fr;?> |
| |
last update |
 |
| |
Contacts |
 |
| |
|
|