Questa Query ha dato errore :
"SELECT F.titolo, F.descrizione, F.immagine FROM m_foto F WHERE F.id_album = AND F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine"
Errore:
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 F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine' at line 1Array
(
[0] => Array
(
[file] => /var/www/clients/client1/web29/web/php/classi/DB.php
[line] => 206
[function] => debugquery
[class] => DB
[object] => DB Object
(
[fDb_host] => localhost
[fDb_user] => avpluserdb
[fDb_password] => xgsRY6#M3b
[fDb_name] => villelucchesi
[fDb] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => 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 F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine' at line 1
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => 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 F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine' at line 1
)
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.3.37-MariaDB-0ubuntu0.20.04.1
[server_version] => 100337
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 7404512
[warning_count] => 0
)
[fResult] =>
[fRow] =>
[fTimeLastQuery] => 1680036436.5796
)
[type] => ->
[args] => Array
(
[0] => SELECT F.titolo, F.descrizione, F.immagine FROM m_foto F WHERE F.id_album = AND F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine
)
)
[1] => Array
(
[file] => /var/www/clients/client1/web29/web/web/elenco_eventi.php
[line] => 71
[function] => query
[class] => DB
[object] => DB Object
(
[fDb_host] => localhost
[fDb_user] => avpluserdb
[fDb_password] => xgsRY6#M3b
[fDb_name] => villelucchesi
[fDb] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => 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 F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine' at line 1
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => 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 F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine' at line 1
)
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.3.37-MariaDB-0ubuntu0.20.04.1
[server_version] => 100337
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 7404512
[warning_count] => 0
)
[fResult] =>
[fRow] =>
[fTimeLastQuery] => 1680036436.5796
)
[type] => ->
[args] => Array
(
[0] => SELECT F.titolo, F.descrizione, F.immagine FROM m_foto F WHERE F.id_album = AND F.lingua = 'ENG' AND F.visibile = 1 ORDER BY F.ordine
)
)
)