MySQL query
Posted: Thu Apr 26, 2007 4:17 am
hi, can someone tell me whats wrong with this query ?
maybe something wrong in CURDATE(), dont have sure about that function in this query
thanks in advance
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";thanks in advance