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

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

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

Storing user data help?
Hey Guys,

I'm not use if this question is to broad but I can always give you more informatio

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

Renaming array keys
The issue: renaming array keys inside a foreach loop.

I'm trying to build a pie chart image w

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba