1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| <?php
$name= addslashes($_GET['name']);
$retour = mysql_query("
SELECT ".$f.".id_studio
FROM ".$f."");
while ($donnees = mysql_fetch_array($retour))
{
$alpha=$donnees['id_studio'];
echo $alpha; alpha donne 23145
}
$nb = mysql_num_rows($donnees);
if ($name=='~')
{
$name3='%';
}
else
{
$name3 = addslashes($_GET['name']).'%';
}
if ($name == '#' )
{
$requete = "SELECT * FROM ".$f." WHERE nom REGEXP '^[0-9].*' ORDER BY nom";
}
else
{
for($i=0;$i<$nb;$i++) // pb ici
{
$retour = mysql_query('SELECT nom,url,pays
FROM studio
LEFT JOIN '.$f.' ON '.$f.'.id_studio = studio.id_studio
WHERE studio.id_studio ='.$alpha[$i].' AND nom LIKE "'.$name3.'" GROUP BY nom;');
}
while ($donnees = mysql_fetch_array($retour))
{
$img=$donnees['pays'];
?>
blablabla html
<?php
} // Fin de la boucle de la liste du studio
close();
?> |
Partager