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 :lol:

merci de ton aide en tout cas

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]SELECT *
FROM label INNER JOIN contenu ON contenu.id_label = label.id_label
Where nom_label REGEXP '^[0-9]'
order by nom_label, reference; [/code]

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 ?

est ce ca ce st ok ? merci encore

[code]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; [/code]

[i][color=darkred][Note : ce message a été posté de manière anonyme avant d'être réattribué à son auteur][/color][/i]

echo $sql;

[quote="stefanelle"]pour le [0-9] ca ne marche pas[/quote]
Pourtant ça devrait ...

Peux-tu rajouter :
[php]echo $sql;[/php]et poster un copié/collé du résultat ?

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 :cry: il m affiche toutes les entrees de mon champ nom_label

$param1 = mysql_real_escape_string($_GET['lettre']);

bonjour,

une solution parmi d'autres ( et peut-être pas la plus rapide ) :
[code] <li><a href="label.php?lettre=[0-9]" target="_self"><span>Label 0 à 9</span></a></li>[/code]

pour éviter les injections SQL :
[php]$param1 = mysql_real_escape_string($_GET['lettre']);[/php]

[code]WHERE nom_label REGEXP '^$param1'[/code]

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

[i][color=darkred][Note : ce message a été posté de manière anonyme avant d'être réattribué à son auteur][/color][/i]

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 ?

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]

<!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();
?> [/code]