esto es lo que que me envia el
MySQL ha devuelto un valor vacío (i.e., cero columnas)
Código PHP:
SELECT p1.Nombre AS id_Cliente, p2.Nombre, p3.Fecha AS Fecha, p4.Nombre AS producto
FROM tblclientes AS p1, tblempleados AS p2, tbl_op AS p3, tblproducto AS p4, tblproducciones AS p5
WHERE '2009-03-02' <= p3.Fecha
AND p3.Fecha <= '2009-03-03'
AND p3.id_op =38
AND p3.id_Cliente = p1.id_Cliente
AND p4.id_Producto = p5.id_Producto
AND p3.id_op = p5.id_op
ORDER BY p3.Fecha
LIMIT 0 , 30
mira el error que envia ahora el sql
Error
consulta SQL:
SELECT p1.Nombre AS id_Cliente, p2.Nombre, p3.Fecha AS Fecha, p4.Nombre AS producto
FROM tblclientes AS p1, tblempleados AS p2, tbl_op AS p3, tblproducto AS p4, tblproducciones AS p5
WHERE ".$fechas." ".$id_opPOST."p3.id_Cliente = p1.id_Cliente
AND p4.id_Producto = p5.id_Producto
AND p3.id_op = p5.id_op
ORDER BY p3.Fecha
LIMIT 0 , 30
MySQL ha dicho:
#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 'p3.id_Cliente = p1.id_Cliente and p4.id_Producto = p5.id_Producto and p3.id_op' at line 1