is anything wrong with this php-sql query? -
could check what's wrong sql query
select distinct a.a a.b tableaa inner join(tablebb b) on(a.a= b.a) inner join(tablecc c) on(a.a = c.a) inner join(tabledd d) on(a.a = d.a) b.c = '$selectedtype' , b.d not '%$selection%' , c.e='$selction111' or d.c = '$selectedtype' , a.d not '%$selection%' , c.e='$selction111'
i have concerns or conditions, want here either conditions between 'where' , 'or' true or below 'or' true.
is way of writing correct? or there other way write?
you looking for:
(b.c = '$selectedtype' , b.d not '%$selection%' , c.e='$selction111') or (d.c = '$selectedtype' , a.d not '%$selection%' , c.e='$selction111')
Comments
Post a Comment