Notice: Fehler bei dem Ausführen eines Mysql-codes!
Mysql-Code:
SELECT
bilderalben.*,
events.datum,
events.id as eventid,
events.title as eventtitel,
events.datum as eventdatum,
locations.title as locationtitel,
locations.id as locationid,
locations.postleitzahl as locationpostleitzahl,
locations.ort as locationort,
users.id as user_id
FROM
bilderalben,
events,
locations,
users
WHERE
bilderalben.id = system
AND
bilderalben.eventsId = events.id
AND
bilderalben.locationsId = locations.id
AND
bilderalben.usersId = users.id
AND
bilderalben.online = 1
Mysql-fehlermeldung:
Unknown column 'system' in 'WHERE' in /www/htdocs/w0134436/weelife.de/system/class/class.mysql.php on line 70
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/htdocs/w0134436/weelife.de/system/class/class.mysql.php on line 264
Notice: Fehler bei dem Ausführen eines Mysql-codes!
Mysql-Code:
SELECT
*
FROM
bilder
WHERE
parentId =
AND
parentTable = "bilderalben"
ORDER BY id ASC
Mysql-fehlermeldung:
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 'AND
parentTable = "bilderalben"
ORDER BY id ASC' at line 7 in /www/htdocs/w0134436/weelife.de/system/class/class.mysql.php on line 70
SELECT
*
FROM
bilder
WHERE
parentId =
AND
parentTable = "bilderalben"
ORDER BY id ASC
Error Mysql 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 'AND
parentTable = "bilderalben"
ORDER BY id ASC' at line 7