ORDER BY FIELD (SELECT compr_sort FROM etc.) [Résolu]

[SpaceFrog]

Voici ma requete:

Code :

1
2
3
4
5
6
7
8
9
10
11
12
$sql=  "SELECT p.id_panier,
	       p.id_pdf,
	       p.code_prod,
	       r.titre_doc,
	       t.desc_type
	FROM paniers AS p, reldocs AS r, typedoc AS t, pdfdocs AS d
	WHERE id_panier =".$compilID." 
	AND p.id_pdf = r.id_pdf
	AND p.code_prod = r.prod_doc
	AND d.id_pdf = p.id_pdf
	AND d.type_pdf = t.code_type
	ORDER BY FIELD(id_panier, (SELECT comp_sort FROM compilheaders WHERE comp_id=".$compilID."))";

le souci est que comp_sort contient un string des id séparés par des virgules

ex: "121,12,569,58,25"

Comment faire ???

On m'a suggéré un debut de piste avec FIND_IN_SET

[SpaceFrog]

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
$sql=  	"SELECT p.id_panier,
		p.id_pdf,
		p.code_prod,
		r.titre_doc,
		t.desc_type
		FROM paniers AS p, reldocs AS r, typedoc AS t, pdfdocs AS d
		WHERE p.id_panier =".$compilID ."
		AND p.id_pdf = r.id_pdf
		AND p.code_prod = r.prod_doc
		AND d.id_pdf = p.id_pdf
		AND d.type_pdf = t.code_type
		ORDER BY FIND_IN_SET( p.id_pdf, (SELECT c.comp_sort
							FROM compilheaders AS c
							WHERE c.comp_id =".$compilID."
							))";

Merci à Julp qui m'a soufflé la piste du FIND_IN_SET