MYSQL ERROR : 1064: 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 'AND
dd.name IS NOT NULL
AND
SUBSTR(dd.name,1,' at line 15
SQL :
SELECT COUNT(*) as cnt FROM
(
SELECT dd.content as Popis,
dd.id ,
dd.name as Name,
dd.perex as perex,
DATE_FORMAT(dd.date,'%d.%m.%Y') as Datum
FROM db_document dd
JOIN db_document dd_parent ON dd_parent.id = dd.db_document_id
WHERE dd.db_database_component_id = 6
AND
dd_parent.id =
AND
dd.name IS NOT NULL
AND
SUBSTR(dd.name,1,1) != '_'
ORDER BY dd.doc_order ASC
)SubT
MYSQL ERROR : 1064: 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 'AND
dd.name IS NOT NULL
AND
SUBSTR(dd.name,1,' at line 12
SQL :
SELECT dd.content as Popis,
dd.id ,
dd.name as Name,
dd.perex as perex,
DATE_FORMAT(dd.date,'%d.%m.%Y') as Datum
FROM db_document dd
JOIN db_document dd_parent ON dd_parent.id = dd.db_document_id
WHERE dd.db_database_component_id = 6
AND
dd_parent.id =
AND
dd.name IS NOT NULL
AND
SUBSTR(dd.name,1,1) != '_'
ORDER BY dd.doc_order ASC
LIMIT 0, 10 Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/axima.cz/httpdocs/dwe/kernel/api/SqlDatabase.php:339) in /var/www/vhosts/axima.cz/httpdocs/dwe/kernel/controls/mpf_page.php on line 379