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 Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

Dynamic memory problem
Hey,

At the beginning of my code, I have this line:

Shape* gShape = 0;

Displaying image from database
Hi,

I've got a site where that's got a database behind it. Currently it has loads of items in

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

how can we add data from dynamic fields to mysql db in php
i have a script which i found on the internet. i modify that script according to my needs. what is i

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

Strange cookie problem. setcookie dependant on where user was directed from?
Hello,

I have a website that sets a cookie when a user visits the website. The cookie holds a

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang