MYSQL
Dotaz:SELECT * FROM korco_product WHERE ID_product = certifikaty-2
Chyba:Unknown column 'certifikaty' in 'where clause'
MYSQL
Dotaz:SELECT *
FROM korco_product prod
WHERE prod.FKID_category =
ORDER BY prod.ord ASC
Chyba:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY prod.ord ASC' at line 4
MYSQL
Dotaz:SELECT *
FROM korco_categories cat
LEFT JOIN korco_category_desc descr ON cat.ID_category = descr.FKID_category
WHERE cat.FKID_type = 3
AND descr.FKID_lang = 1
AND cat.ID_category =
ORDER BY cat.ord ASC
Chyba:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY cat.ord ASC' at line 7
MYSQL
Dotaz:SELECT * FROM korco_product WHERE ID_product = certifikaty-2
Chyba:Unknown column 'certifikaty' in 'where clause'
MYSQL
Dotaz:SELECT price.amount AS price_basic,
size.frame_base_price AS price_basic_frame,
size.frame_extra_cm_price AS price_extra_frame
FROM korco_product prod
LEFT JOIN korco_product_price price ON prod.ID_product = price.FKID_product
LEFT JOIN korco_product_size size ON price.FKID_size = size.ID_size
WHERE prod.ID_product= certifikaty-2
AND price.FKID_size = 1
Chyba:Unknown column 'certifikaty' in 'where clause'