Forum

Cod: Selectaţi tot

			$sql = sprintf("SELECT *, p.id as pid FROM produse p 
							INNER JOIN categorii c on p.categorie=c.id
							LEFT JOIN product_attribute pa on p.id=pa.product_id
							LEFT JOIN attribute_description ad on pa.attribute_id=ad.attribute_id
							WHERE c.seo = '%s' AND p.vizibil= 1", $_GET['c']);

Cod: Selectaţi tot

SET @sql = NULL;
SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'MAX(IF(ad.name = ''',
      name,
      ''', pa.text, NULL )) AS ',
      replace(name,' ', '_')
    )
  ) INTO @sql
FROM attribute_description, product_attribute;

SET @sql = CONCAT('SELECT p.id
                    , p.titlu
                    , p.descriere, ', @sql, ' 
                   FROM produse p
                   LEFT JOIN product_attribute AS pa 
                   ON p.id = pa.product_id
                   LEFT JOIN attribute_description AS ad
                   ON pa.attribute_id = ad.attribute_id where p.vizibil=''1'' 
                group by id having tara_de_origine = "romania" and instant = "da"');

PREPARE stmt FROM @sql;
EXECUTE stmt;

Cod: Selectaţi tot

#1243 - Unknown prepared statement handler (stmt) given to EXECUTE

Cod: Selectaţi tot

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT GROUP_CONCAT(DISTINCT CONCAT( 'MAX(IF(ad.name = ''', name, ''', pa.t' at line 2