Ini y Fin
Cliente
TODOS
SELECT fo.idfo,fo.idim,fo.tipo_foto,fo.foto,fo.direccion,fo.fecha,fo.latitude,fo.longitude ,i.tipo,f.idfa,f.nombre as PDV,u.idus,u.nombre as Representante,u.foto as avatar ,l.idla,l.nombre as cliente FROM (select * from fotografias where DATE_FORMAT(fecha,'%Y-%m-%d') between '' and '') fo INNER JOIN impactos i ON fo.idim=i.idim INNER JOIN farmacias f ON i.idfa=f.idfa INNER JOIN usuarios u ON i.idus=u.idus INNER JOIN laboratorios l ON f.idla=l.idla WHERE 1=1 and f.idla= and u.idus= and f.idfa= and i.tipo='' order by fo.idfo desc;
Fatal error
: Uncaught mysqli_sql_exception: 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 u.idus= and f.idfa= and i.tipo='' order by fo.idfo desc' at line 10 in /home/planbtlpharma/public_html/sistema/dashboard_galeriaimagenes.php:258 Stack trace: #0 /home/planbtlpharma/public_html/sistema/dashboard_galeriaimagenes.php(258): mysqli->query('\nSELECT fo.idfo...') #1 {main} thrown in
/home/planbtlpharma/public_html/sistema/dashboard_galeriaimagenes.php
on line
258