form with select tags

reisrui

Hi,

I have a php page in which I have a form that has 2 select tags. I´m obtaining its option values from a mysql table and it presents ok.

What i want to do is to join the options one selects and query the table with it!
I also added manually one last option value to each select tag (After the ones from the table) saying the user to choose "all", so that if one chooses the first select with "all" and the second select with any value, it should query only with the second option and vice-versa.

How can I do this, so it presents the results right after the form in the same page?
How to refresh the options choosen? (by default the table should return empty)

many thanks
rr

notaloser

if you are trying to say you have 2 combo boxes, and you want the contents of the second one to be controlled by what is selected in the first one all on the same page, you need to use javascript and php together..

reisrui

No, not combos.

It´s 2 list boxes and no one depends on the other.

They just refer to 2 different fields of the same DB, and I want to query that DB with the parameters one chooses on the 2 list boxes, so that the results appear in the same page.

notaloser

combo boxes are the same thing as list boxes,
and if your asking what i think you are, it is very simple


//PLACE ALL YOUR FORM HTML UP HERE

<?php

if($_POST['submit']) {

$listval1 = $_POST['firstlist'];
$listval2 = $_POST['secondlist'];

$query = mysql_query("SELECT * FROM table WHERE dbcolumn1 = '".$listval1."' AND dbcolumn2 = '".$listval2."'");

while($row = mysql_fetch_array($query)) {

echo "your first selection: ".$row['dbcolumn1'];
echo "your second selection: ".$row['dbcolumn2'];

}

}

here, when the submit button is pressed, $listval1 and $listval2 are whatever the user has selected as the values of the boxes, and then $query is executed with $listval1 and $listval2 limiting your results.

then, your results are put into an array and displayed

reisrui

Thanks notaloser,

I´m getting there...
Should the form be calling to the self page and with method post?
Instead of using this:
$query = mysql_query("SELECT * FROM table WHERE dbcolumn1 = '".$listval1."' AND dbcolumn2 = '

Can I use "... dbcolumn1 like '%".$listval1."%' AND dbcolumn2 like '%".$listval2."%'....", so that I can choose one listval as empty?

notaloser

you can either user GET or POST, but i suggest POST.

$query = mysql_query("SELECT * FROM table WHERE dbcolumn1 LIKE '%".$listval1."%' AND dbcolumn2 = '%".$listval2."%' ");

this will select ALL rows in your database WHERE dbcolumn1 has the value $listval1 anywhere in it and dbcolumn2 has the value $listval2 anywhere in it.

reisrui

Ok, that´s what I wanted.
Many thanks.

reisrui

Just another related issue:
How can I make my sql query string to something like ("SELECT * FROM $table....")
in which I can change the variable $table before according to if´s I have?
I tried .... FROM '$table'....
I tried .... FROM "$table" ....
Always returns errors like "supplied argument is not valid"