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

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

Using Curl_multi for processing multiple URLs
Hi,

I am at a loss as to how to implement this. I would like to be able to automatically assi

Alterar a hora do servidor
Se alguém souber, ajude-me a adicionar 6 horas, obrigado
<tr>
&

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

passing data from one page to another
hey guys
i have the follwoing code to get information from one page and place on another:

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl