query("SELECT DISTINCT(pt_nom), pt_code_tiers, pt_id FROM " . $db_final . " LEFT JOIN " . $db_type . " ON p_type=pt_code_tiers WHERE p_categorie LIKE '" . $categorie->pc_code_tiers . "' AND p_famille LIKE '" . $principal . "' AND " . $priceType . "!='0' ORDER BY pt_nom"); ?> rowCount(); ?> fetch(PDO::FETCH_OBJ)) { $href = null; $href .= (isset($_GET['format'])) ? '-' . $_GET['format'] : null; $href .= (isset($_GET['support'])) ? '-' . $_GET['support'] : null; $href .= (isset($_GET['impression'])) ? '-' . $_GET['impression'] : null; $href .= (isset($_GET['quantite'])) ? '-' . $_GET['quantite'] : null; $href .= (isset($_GET['pages'])) ? '-' . $_GET['pages'] : null; ?> pt_id; ?>', 'pt_code_tiers; ?>', 'pc_code_tiers; ?>');">pt_nom); ?> */ ?> pc_infos)) echo '
' . $categorie->pc_infos . '
'; ?> query("SELECT DISTINCT(pfo_code_tiers), pfo_largeur, pfo_hauteur, pfo_reference, pfo_id FROM " . $db_final . " LEFT JOIN " . $db_format . " ON p_format=pfo_code_tiers WHERE p_type LIKE '" . $_GET['type'] . "' AND p_categorie LIKE '" . $categorie->pc_code_tiers . "' AND p_famille LIKE '" . $principal . "' AND " . $priceType . "!='0' ORDER BY pfo_reference"); ?> rowCount(); ?>produits->format); ?>
' : ''; $fref .= (!empty($p->pfo_largeur)) ? htmlentities($p->pfo_largeur) . ' x ' : ''; $fref .= (!empty($p->pfo_hauteur)) ? htmlentities($p->pfo_hauteur) : ''; ?>
produits->support); ?>
query("SELECT DISTINCT(p_support), CONCAT(ps_nom, 'g/m² ', ps_type) AS _support FROM " . $db_final . " LEFT JOIN " . $db_support . " ON ps_code_tiers=p_support WHERE p_format LIKE '" . $_GET['format'] . "' AND p_type LIKE '" . $_GET['type'] . "' AND p_categorie LIKE '" . $categorie->pc_code_tiers . "' AND p_famille LIKE '" . $principal . "' AND " . $priceType . "!='0' ORDER BY ps_nom"); $counts = $supports->rowCount(); ?>produits->impression); ?>
query("SELECT DISTINCT(p_impression), pi_nom AS _impression FROM " . $db_final . " LEFT JOIN " . $db_impression . " ON pi_code_tiers=p_impression WHERE p_format LIKE '" . $_GET['format'] . "' AND p_type LIKE '" . $_GET['type'] . "' AND p_support LIKE '" . $_GET['support'] . "' AND p_categorie LIKE '" . $categorie->pc_code_tiers . "' AND p_famille LIKE '" . $principal . "' AND " . $priceType . "!='0' ORDER BY pi_nom"); $counti = $impressions->rowCount(); ?>produits->quantite); ?>
query("SELECT DISTINCT(p_quantite), pq_quantite AS _quantite FROM " . $db_final . " LEFT JOIN " . $db_quantite . " ON pq_code_tiers=p_quantite WHERE p_impression LIKE '" . $_GET['impression'] . "' AND p_format LIKE '" . $_GET['format'] . "' AND p_type LIKE '" . $_GET['type'] . "' AND p_support LIKE '" . $_GET['support'] . "' AND p_categorie LIKE '" . $categorie->pc_code_tiers . "' AND p_famille LIKE '" . $principal . "' AND " . $priceType . "!='0' ORDER BY pq_quantite"); $countq = $quantites->rowCount(); ?>query("SELECT DISTINCT(p_pages), pp_nom AS _pages FROM " . $db_final . " LEFT JOIN " . $db_pages . " ON pp_code_tiers=p_pages WHERE p_impression LIKE '" . $_GET['impression'] . "' AND p_format LIKE '" . $_GET['format'] . "' AND p_type LIKE '" . $_GET['type'] . "' AND p_support LIKE '" . $_GET['support'] . "' AND p_categorie LIKE '" . $categorie->pc_code_tiers . "' AND p_famille LIKE '" . $principal . "' AND " . $priceType . "!='0' AND p_pages!='0' ORDER BY pp_nom"); ?> rowCount() > 0) { $countp = $pages->rowCount(); ?>