select *,
(
    CASE 
        WHEN (CURDATE() between sconto_inizio and sconto_fine) and giacenza > 0 THEN prezzoweb-((prezzoweb/100)*sconto_percent)
        ELSE prezzoweb
    END) AS scontato from titoli_home WHERE MATCH ( autore ) 
      AGAINST ('+peter+abrahams+' IN BOOLEAN MODE) and visibile = 1 ORDER BY titolo ASC<BR><BR>syntax error, unexpected $end