Page 1 of 1

MySQL query

Posted: Thu Apr 26, 2007 4:17 am
by bouncer
hi, can someone tell me whats wrong with this query ?

Code: Select all

"SELECT *,a.data AS data, a.activo AS activo, a.id AS id, b.codigo AS codigo, a.preco AS preco, a.id_cliente AS id_cliente, b.id AS cod_prod FROM antileilao a INNER JOIN produtos b ON a.id_produto = b.codigo WHERE a.mostra = 1 AND a.activo = 1 AND CURDATE() <= a.datafim ORDER BY a.data";
maybe something wrong in CURDATE(), dont have sure about that function in this query :wink:

thanks in advance

Posted: Thu Apr 26, 2007 4:34 am
by JayBird
Whats the problem/error?

Posted: Thu Apr 26, 2007 5:20 am
by bouncer
i dont get any data using this query, if i remove "CURDATE()<=a.datafim", the query works :?

problem solved :D

thanks in advance