[SOLVED] how to use form for filtering ??

[janim]

hi every body

i wanna use simple filter like this  :

<form action="" method="post" >
<select name="select2">
      <option value="new">new</option>
      <option value="old">old</option>
    </select>   
</form>
<?
$filter="id desc";
$filter="id asc";
$filter="anything else";

$showing=mysql_db_query($bas,"select * from $movtab  order by $filter ) or die
?>

 

as you see i can't detect what is will change the $filter variable

so any suggestion please

[~n[EO]n~]

What are you trying to do ?

[kyleabaker]

If you want the content that you're filtering to change as you pick new or old then you will need either ajax to change it in a container on the page or just reload the page with the settings that are selected. However, I also would need more details as to what you are trying to do..?

 

If you are planning to reload the page when the form is submitted then you could use $HTTP_POST_VARS or $_GET to grab the settings you select and sort the content. You could also set the default selected item in the select box by echoing the options out and adding (I think this is correct) "selected" inside the <option> tag.

[janim]

yea thank you kyleabaker

that's right

i have done it with <form method="get" action "">

 

it's with that simple

so if you interested in code i will post it

 

[kyleabaker]

Go a head and post some of your code and I'll see if I can help more.