Dynamic Conditions in PHP form

[coool]

 

I have this:

SELECT $items FROM $table WHERE $conditions

 

in my form I'm asking the user to select items from a list - multible selections

and I'm asking the user to select from which table he/she would like to extract the data

 

now my problem with the conditions selection !

 

I'm going to divide this problem to smaller ones and solve each one then relate it to the other

 

I've already created a list that have all the fields available (user can only select one item)

and I've already created a list with the values (multible selection is available)

 

example:

item1 is being chose___user can choose the relation(In/Not In..etc)___list of unique values of item1

 

should i use java to remember the first selection then i can use this selection in my second list sql so i can get the values that are related to this selection ?

 

do you know any java script that will save selection then read it later and use it as a variable in my second sql ?

[frost]

You could store the info in a cookie, or use GET to post the each selection of the form.

 

form.php?item1=response1&item2=response2&item3=response3

 

Would that work?

[coool]

how would I store in Cookie ! never done it before !

[trq]

setcookie().

[coool]

 

There's something I don't understand here !

 

in order in use $_POST, you need to submit the form, right ?

 

look at this:

<?
$firstQry = mysql_query("SHOW FIELDS FROM table1") or die(mysql_error());      // table 1
?>
<form name="check" method="post">
        <select name="first" onchange="this.form.submit()">
            <?
                while($res = mysql_fetch_row($firstQry))
                {?>
                   <option  value="<? echo $res[0]?>"><? echo $res[0]?></option>
             <? }
                unset($firstQry,$res);?>
        </select>

        <? if(isset($_POST["first"]))
        {
        $sql2 = "Select ".$_POST['first']." FROM table1 GROUP BY ".$_POST['first'];
        $secondQry = mysql_query($sql2) or die(mysql_error());
?>        <select size="3" multiple name="second[]">
            <? while($row = mysql_fetch_row($secondQry)){?>
                <option  value="<? echo $row[0]?>"><? echo $row[0]?></option>
            <? }
           } unset($secondQry,$row);?>
        </select>
</form>

<?
echo "<br/>";
echo "first: ".$_POST['first'];

echo "<br/>";
echo "second: ".implode($_POST['second'],",");

 

the problem is

 

when i choose item2 in the first list

values of item2 appear in the second list

 

then

when i select few values from second list

and select a new field in first list ( let's say item5 )

 

form is submitted ! I get as an output

list1 =  item 5

list2 = values of item2

 

what i need is the match to appear.. item 2 with its values

 

how can i use cookie ! or store session in my code above !

[frost]

Do you have this online somewhere?

[coool]

I've got the code from the internet

 

but forgot where !

 

why do you need it online !

 

please just give some clues of how to fix the problem or a small example !

[coool]

 

okay let me forget for now doing the dependent lists

 

first this is what i'm planning to have

 

http://img76.imageshack.us/my.php?image=criteriafz2.jpg

 

I'm wondering how can i by a click have a new criteria line

 

then all criteria lines should be saved to thier variables ! so i can use them later inside a sql query statement after the word "WHERE"

 

do i have to use java script ! .. or do i have to use php functions ! or multiple forms submitions !! ..