Page 1 sur 1
php/sql order by
Posté : 21 févr. 2009, 14:09
par stefanelle
Bonjour,
j ai fichier php qui m affiche un menu avec un tableau résultat d un select entre deux tables tout fonctionne super sauf que pour que le résultat s affiche dans la page et par première lettre label a, label b ... j ai mis un get me permettant d afficher les label par première lettre, mon souci est que je veux afficher également ceux commençant par un chiffre mais quand je mets 0, 1 ou 2 ca fonctionne mais comment faire en sorte qu il prenne tous les chiffres de 0 à 9 ?
Code : Tout sélectionner
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional //EN"
"http://www.w3.org/TR/xhtmll/DTD/xhtmll-transitional.dtd">
<html Xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>listing</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<ul class="menu">
<li><a href="label.php?lettre=0" class="active"><span>Label 0-
9</span></a></li>
<li><a href="label.php?lettre=A" target="_self"><span>Label A</span></a></li>
<li><a href="label.php?lettre=B" target="_self"><span>Label B</span></a></li>
<li><a href="label.php?lettre=C" target="_self"><span>Label C</span></a></li>
<li><a href="label.php?lettre=D" target="_self"><span>Label D</span></a></li>
<li><a href="label.php?lettre=E" target="_self"><span>Label E</span></a></li>
<li><a href="label.php?lettre=F" target="_self"><span>Label F</span></a></li>
<li><a href="label.php?lettre=G" target="_self"><span>Label G</span></a></li>
<li><a href="label.php?lettre=H" target="_self"><span>Label H</span></a></li>
<li><a href="label.php?lettre=I" target="_self"><span>Label I</span></a></li>
<li><a href="label.php?lettre=J" target="_self"><span>Label J</span></a></li>
<li><a href="label.php?lettre=K" target="_self"><span>Label K</span></a></li>
<li><a href="label.php?lettre=L" target="_self"><span>Label L</span></a></li>
<li><a href="label.php?lettre=M" target="_self"><span>Label M</span></a></li>
<li><a href="label.php?lettre=N" target="_self"><span>Label N</span></a></li>
<li><a href="label.php?lettre=o" target="_self"><span>Label O</span></a></li>
<li><a href="label.php?lettre=P" target="_self"><span>Label P</span></a></li>
<li><a href="label.php?lettre=Q" target="_self"><span>Label Q</span></a></li>
<li><a href="label.php?lettre=R" target="_self"><span>Label R</span></a></li>
<li><a href="label.php?lettre=S" target="_self"><span>Label S</span></a></li>
<li><a href="label.php?lettre=T" target="_self"><span>Label T</span></a></li>
<li><a href="label.php?lettre=U" target="_self"><span>Label U</span></a></li>
<li><a href="label.php?lettre=V" target="_self"><span>Label V</span></a></li>
<li><a href="label.php?lettre=W" target="_self"><span>Label W</span></a></li>
<li><a href="label.php?lettre=X" target="_self"><span>Label X</span></a></li>
<li><a href="label.php?lettre=Y" target="_self"><span>Label Y</span></a></li>
<li><<a href="label.php?lettre=Z" target="_self"><span>Label Z</span></a></li>
<br></br>
<br></br>
<br></br>
<br></br>
<br></br>
<?php
include ('config.php');
include ('connexion.php');
echo '<table>
<tr>
<th>Label</th>
<th>Référence</th>
<th>Artiste</th>
<th>Album</th>
<th>Format</th>
<th>Modifier</th>
<th>Supprimer</th>
</tr>';
// paramètre reçu désignant le critère du nom du label recherché
$param1 = ($_GET['lettre']);
//
$sql = "SELECT * FROM label
INNER JOIN contenu ON contenu.id_label = label.id_label
Where nom_label LIKE '$param1%' order by nom_label, reference;
";
$req = mysql_query($sql);
while ($resultat = mysql_fetch_array($req))
{
echo '<tr>';
echo '<td>'.$resultat['nom_label'].'</td>';
echo '<td>'.$resultat['reference'].'</td>';
echo '<td>'.$resultat['artiste'].'</td>';
echo '<td>'.$resultat['album'].'</td>';
echo '<td>'.$resultat['format'].'</td>';
echo '<td><a href="formulaire_de_mise_a_jour.php?reference='.$resultat
['reference'].'">Modifier</a></td>';
echo '<td><a href="script_de_suppression.php?reference='.$resultat
['reference'].'">Supprimer</a></td>';
echo '</tr>';
}
echo '</table>';
?>
</body></html>
<?php
mysql_close();
?>
Posté : 21 févr. 2009, 22:54
par Aureusms
Comprend pas pour le 0,1,2 et pas les autres chiffres.
Si $param1 = 0 ou 1 ou 2 c'est Ok d'après ce que je comprend mais pas pour les autres chiffres ?
nom_label est sous quelle forme? varchar ?
Posté : 22 févr. 2009, 02:52
par stefanelle
en fait si je mets que le 0 ca marche si je mets que le 1 ca marche mais comment faire en sorte qu il prenne tous les chiffres de 0 à 9
[Note : ce message a été posté de manière anonyme avant d'être réattribué à son auteur]
Posté : 22 févr. 2009, 08:26
par blof
bonjour,
une solution parmi d'autres ( et peut-être pas la plus rapide ) :
Code : Tout sélectionner
<li><a href="label.php?lettre=[0-9]" target="_self"><span>Label 0 à 9</span></a></li>
pour éviter les injections SQL :
$param1 = mysql_real_escape_string($_GET['lettre']);
Posté : 22 févr. 2009, 10:17
par stefanelle
Bonjour,
Merci de ta réponse pour le code anti sql inject nickel chrome merci pour l astuce
pour le [0-9] ca ne amrche pas
il m affiche toutes les entrees de mon champ nom_label
Posté : 22 févr. 2009, 11:10
par blof
pour le [0-9] ca ne marche pas
Pourtant ça devrait ...
Peux-tu rajouter :
echo $sql;
et poster un copié/collé du résultat ?
Posté : 22 févr. 2009, 11:49
par stefanelle
est ce ca ce st ok ? merci encore
Code : Tout sélectionner
SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference; SELECT * FROM label INNER JOIN contenu ON contenu.id_label = label.id_label Where nom_label REGEXP '^[0-9]' order by nom_label, reference;
Posté : 23 févr. 2009, 12:31
par Ryle
Je ne sais pas s'il est normal que ton select apparaissent 23 fois, mais on va supposer que c'est parce que le echo était dans la boucle
Code : Tout sélectionner
SELECT *
FROM label INNER JOIN contenu ON contenu.id_label = label.id_label
Where nom_label REGEXP '^[0-9]'
order by nom_label, reference;
La requête générée à l'air correcte... supprime toutefois le ";" final et laisse le soin au parser sql de l'ajouter s'il en a besoin...
Quel est le résultat si tu exécutes cette requête directement dans MySQL ou phpMyAdmin ?
Posté : 23 févr. 2009, 12:50
par stefanelle
alors la .............................
je viens de tester et ca fonctionne avec ce que tu m as donné surement un probleme de refresh du navigateur que pourtant j avais rafraichi ctrl+f5 sous firefox
merci de ton aide en tout cas