2 variables in 1 select statement PHP

Question

I've managed to have a working code with this

if ($kurs){
            $search_str .= $search_str ? ' AND ': 'WHERE' ;
            $search_str .= "`tblalumni`.`course` LIKE '%" .$kurs."%' "; 
        }

As you can see it's just have one variable, I would like to have a SQL BETWEEN Operator within two variable

here it is but it is not working

if ($year1)AND($year2){
            $search_str .= $search_str ? ' AND ': 'WHERE' ;
            $search_str .= "`tblalumni`.`yeargrad` BETWEEN '%" .$year1."%' AND '%" .$year2."%' "; 
        }

This is the error

Parse error: syntax error, unexpected 'AND' (T_LOGICAL_AND) in C:\xampp\htdocs\new1v2\admin\alumni_search_list.php on line 40

Please help me T_T

marlonjd · Accepted Answer · 2017-02-19T15:56:15.090

0

if ($year1 && $year2) {
            $search_str .= $search_str ? ' AND ': 'WHERE' ;
            $search_str .= "`tblalumni`.`yeargrad` BETWEEN '%" .$year1."%' AND '%" .$year2."%' "; 
        }

Try this sorry i could't comment

edited Feb 19 '17 at 15:56

answered Feb 19 '17 at 15:35

marlonjd

135
10

already did that but you're answer is correct! thank you! – lokis Feb 19 '17 at 16:30
You're welcome. Thank you for keeping it could be useful for other persons. Have fun in your project – marlonjd Feb 19 '17 at 19:37

2 variables in 1 select statement PHP

1 Answers1