$query = "SELECT bib_publications.title FROM bib_publications WHERE (".
(($radio2=='civil_year')? "bib_publications.year BETWEEN ".$year1." AND ".$year2 : "(bib_publications.year=".$year2."AND bib_publications.month1 IN ('January','February','March','April','May','June','July','August')) OR (bib_publications.year=".(($year1)-1)."AND bib_publications.month1 IN ('September','October','November','December'))".
(($year1 < $year2)? " OR (bib_publications.year BETWEEN ".$year1." AND ".(($year2)-1).")".)) .") ORDER bib_publications.title DESC;";
===================
what i want(it seems that i can't use if..else so i have to translate it to (cond ? ..:..)):
if($radio2=='civil_year') ."bib_publications.year BETWEEN ".$year1." AND ".$year2".
else{
."(bib_publications.year=".$year2."AND bib_publications.month1 IN ('January','February','March','April','May','June','July','August')) OR (bib_publications.year=".(($year1)-1)."AND bib_publications.month1 IN ('September','October','November','December'))".
if($year1 < $year2) ."OR (bib_publications.year BETWEEN ".$year1." AND ".(($year2)-1).
}