I am trying to design a database call to operate from a filter control so that I can select things out of the DB depending on which options are selected on the UI. However I need to first check that the syntax I have in mind will work with MYSQL as I don't use many statements of this type.
For example I know you can use the SELECT * from DB method but what if I were to pass it a php variable "*" would that then allow me to go:
SELECT * from DB WHERE manufacturer="samsung" and price = $var // var is a string "*"
which would then filter a specific manufacturer but disregard whether the user had selected a particular price range so my meaning is get any price
or vice versa could I go
SELECT * from DB WHERE manufacturer=$var and price >= "50" /. to get all manufacturers but a particular price?
I know the punctuation is a little off but its only an illustration, I would be very grateful if someone could help me