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

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Comma seperated implode & modifying returned string.
I have a PHP post form that posts up to 4 variables. I need whatever variables are passed to be comb

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name