How to search for several parameters from objects in a database?

Posted on 16th Feb 2014 07:03 pm by admin

I have a database with lots of information about objects.
Now I would like to search for 4 or 5 parameters at the same time (from a form) like this:

I choose from a select-box one parameter and then from another select-box (in the same form) another parameter.
Now I want all the objects that fit in with all the chosen parameters to be shown.

I have tried this:
Code: $query = "SELECT * FROM vaxtlista WHERE farg='$farg' AND typ='$typ' ORDER BY vetenskapligt";
and this:
Code: $query = "SELECT * FROM vaxtlista WHERE (farg='$farg' AND typ='$typ') ORDER BY vetenskapligt";
I don´t use LIKE and jokers because I know exactly what´s in the fields.

Nothing works.

Someone who has a clue about this? Please help

Your Answer:

Login to answer

Other forums

Strange array issue, never happened before.
mysql_fetch_array returns 1 array per call. Generally that's why it is inserted into a while statem

Google voice
I currently have a form in html, but I want it in php so the information is not in the source code.<

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

random generation
hi

i need help with generating this

numbers from 1-12

i want to generate in ran

Mail functionality from localhost to server
Hi

I am facing problem of mail functionality.

When i tested mail functionality in my

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.