jpn

 kod sql uzytkownika unbreak ponizej

Wszystko w cytowanym kodzie pod phpmyadmin dziala poza description ta kolumna jest u mnie pusta a jest dla mnie jedna z wazniejszych

SELECT p.id_product, pl.name, p.price, p.condition, p.available_for_order, pl.description , c.name as category_name,
concat('www.nazwasklepu.com/index.php?controller=product&id_product=',p.id_product) as full_link,
concat( 'www.www.nazwasklepu.com', '/img/p/',mid(pi.id_image,1,1),'/', if (length(pi.id_image)>1,concat(mid(pi.id_image,2,1),'/'),''),if (length(pi.id_image)>2,concat(mid(pi.id_image,3,1),'/'),''),if (length(pi.id_image)>3,concat(mid(pi.id_image,4,1),'/'),''),if (length(pi.id_image)>4,concat(mid(pi.id_image,5,1),'/'),''), pi.id_image, '.jpg' ) AS image_link
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_lang c ON (p.id_category_default = c.id_category)
RIGHT JOIN ps_image pi ON (pi.id_product = p.id_product)
WHERE p.active = 1 AND pl.id_lang = 1 AND pi.cover = 1

Chcialbym zeby u mnie wygladal tak

dodac kolumne pl.description_short  i usunac full_link co wyswietla pelen url id_product

Niby powinno to wygladac tak wg mnie (pojecie o skladni sql zerowe mam i pewnie tu lezy przyczyna)

SELECT p.id_product, pl.name, p.price, p.condition, p.available_for_order, pl.description, pl.description_short, c.name as category_name,
concat( 'projekt.pl', '/img/p/',mid(pi.id_image,1,1),'/', if (length(pi.id_image)>1,concat(mid(pi.id_image,2,1),'/'),''),if (length(pi.id_image)>2,concat(mid(pi.id_image,3,1),'/'),''),if (length(pi.id_image)>3,concat(mid(pi.id_image,4,1),'/'),''),if (length(pi.id_image)>4,concat(mid(pi.id_image,5,1),'/'),''), pi.id_image, '.jpg' ) AS image_link
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_lang c ON (p.id_category_default = c.id_category)
RIGHT JOIN ps_image pi ON (pi.id_product = p.id_product)
WHERE p.active = 1 AND pl.id_lang = 1 AND pi.cover = 1

no ale po wykonaniu kodu i tak kolumny description, description_short sa puste (bledow zadnych nie wywala)

z kolei przy wykonaniu takiego kodu

znaleziony gdzies w odmetach internetu

SELECT p.id_product AS 'ID',
p.active AS 'Active (0/1)',
pl.name AS 'Name',
p.id_category_default AS 'Default Category',
p.price AS 'Price tax excl.',
p.id_tax_rules_group AS 'Tax rules ID',
p.wholesale_price AS 'Wholesale price',
p.reference AS 'Reference #',
p.quantity AS 'Quantity',
pl.description_short AS 'Short description',
pl.description AS 'Description',
pl.meta_title AS 'Meta-title',
pl.meta_keywords AS 'Meta-keywords',
pl.meta_description AS 'Meta-description',
pl.available_now AS 'Text when in stock',
pl.available_later AS 'Text when backorder allowed',
p.available_for_order AS 'Available for order',
p.date_add AS 'Product creation date',
p.show_price AS 'Show price',
p.online_only AS 'Available online only',
p.condition AS 'Condition',
concat( 'http://', ifnull( conf.value, 'projekt.pl' ) , '/img/p/',mid(p.id_product,1,1),'/', if (length(p.id_product)>1,concat(mid(p.id_product,2,1),'/'),''),if (length(p.id_product)>2,concat(mid(p.id_product,3,1),'/'),''),if (length(p.id_product)>3,concat(mid(p.id_product,4,1),'/'),''),if (length(p.id_product)>4,concat(mid(p.id_product,5,1),'/'),''), p.id_product, '.jpg' ) AS url_image
FROM ps_configuration conf, ps_product p
INNER JOIN ps_product_lang pl ON p.id_product = pl.id_product
LEFT JOIN ps_supplier_lang sl ON p.id_supplier = sl.id_supplier
LEFT JOIN ps_manufacturer_lang ml ON p.id_manufacturer = ml.id_manufacturer
WHERE conf.name = 'PS_SHOP_DOMAIN'

kolumny description, description_short i reszte wyswietla juz prawidlowo przy pogladzie w phpmyadmin ale przy eksporcie do pliku cos sie zapetla i pobiera sie plik ktory wazy kilkaset mb zamiast max 10mb i nie idzie tego odtworzyc

Jakies pomysły?

Z góry dzięki za odpowiedź