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

Page Reload
I am having issues getting a page to reload after I submit data to a database. This form should inp

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.

In a nutshell, the first page is entirely html

file downloaded can't be read !!
<?php
$fileName = 'mypic.jpg';
$mimeType = 'image/jpeg';
header('content-dispositio

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

links using header()
Hi All

I'm not sure where to ask for help on this but I hope someone can offer some. I'm at

URL Rewrite issue
Im created a series of Rewrites and on page checks to make sure the correct url is being called. But

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am