Query from form.

[Anon]

Hi.

I have a problem with getting a dynamic query from my form. I have four checkboxes. I want the user to combine them... so if you check box x and y, the query should look like: "SELECT * FROM table WHERE (x = 1 AND y = 1)"

At the moment I use this script which doesn't work exactly the way I would like it to do:

$query = "SELECT * FROM table WHERE (text = 'something_noone_would_type_in'";

if ( $schmal == "1" ) {$query .= " OR schmal = '1'";};
if ( $breit == "1" ) {$query .= " OR breit = '1'";};
if ( $klassisch == "1" ) {$query .= " OR klassisch = '1'";};
if ( $modern == "1" ) {$query .= " OR modern = '1'";};
$query .= ")";

I am really ashamed of that code!!! 🙂 So, could you please help me with it?

Thank you so much!

Julia

[Anon]

You don't need ()
Try this:

$sql = "SELECT * FROM table WHERE text = 'whatever'";

$sql.= ($schmal == 1) ? "OR schaml = 1" : "";
$sql.= ($breit == 1) ? "OR breit = 1" : "";
$sql.= ($klassich == 1) ? "OR klassisch = 1" : "";
$sql.= ($modern == 1) ? "OR modern = 1" : "";

ta-da

Hope this helps

P.D: ? : is a shorcut for if-else. Just in case you want to restrict in case that option was NOT selected.

fLIPIS

[Anon]

Thank you,

but that didn't really answer my question.
Does anyone have a solution for my problem?

Julia

[Anon]

In my code, use AND instead of OR. That will restrict the search to those records containintg the two values you specify (criteria), not just one of them.

Hope this is what you want

fLIPIS