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