Hola una vez mas Quim,
Bueno pues si que era mas simples de lo que me parecia !! Simplesmente he cambiado
Código PHP:
$sql = "SELECT pd_id, pd_auteur, pd_titre, pd_editeur, cat_name, pd_isbn, pd_descriptif, pd_price, pd_etat, pd_thumbnail, pd_qty, c.cat_id, c.cat_name
FROM tbl_product pd, tbl_category c
WHERE pd.cat_id = c.cat_id AND pd.cat_id IN $children
ORDER BY pd_titre ASC";
A
Código PHP:
$sql = "SELECT pd_id, pd_auteur, pd_titre, pd_editeur, cat_name, pd_isbn, pd_descriptif, pd_price, pd_etat, pd_thumbnail, pd_qty, c.cat_id, c.cat_name
FROM tbl_product pd, tbl_category c
WHERE pd.cat_id = c.cat_id AND pd.cat_id IN $children
OR pd.cat_id2 = c.cat_id AND pd.cat_id2 IN $children
OR pd.cat_id3 = c.cat_id AND pd.cat_id3 IN $children
ORDER BY pd_titre ASC";
Y ahora va de maravilla !!
Gracias Quim !!