Keeping current query string and adding to it.

[lakeripple]

I send a query string to a page where what I want to do is allow the user to sort the data based on what they want from a drop down menu. Here is what I have so far and its not working.

		<form name="form1" method="get" action="results.php<?php if (isset($_SERVER['QUERY_STRING'])) { echo "?".$_SERVER['QUERY_STRING']; } ?>">
            <div align=center><span class=style12>Sort by</span> 
                <select name=select>
                  <option>name</option>
                  <option>family</option>
                  <option>level</option>
                </select>
                <input type=submit name=Submit value=Sort />
              </div>
          </form>

Any ideas how to get it working? Or other ways to do this...?

[bpat1434]

What are you sorting? The Query_String refers to posted variables, not a mysql query...

~Brett

[lakeripple]

Im sorting a table that allready has variables, i want to add another string to "example.php?thing=blahblah&thing2=blah" so that it keeps the current url and adds to it -> "example.php?thing=blahblah&thing2=blah&thing3=blahh"

[bpat1434]

Well, if query string doesn't seem to be working, then I'd say do this:

<?php

$queryString = '';

for($i=0; $i<count($_GET); $i++)
{
  $queryString .= ($i==0)?'?':'&';
  $queryString .= $var.'='.$val;
}
?>

Then use that querystring value in place of $_SERVER['Query_STRING'].

~Brett

[lakeripple]

I've tried :

		$url = 'results.php?filter=$filter_Recordset1&search=$search_Recordset1&';
		echo "<form name=form1 method=get action='$url'
            <div align=center><span class=style12>Sort by</span> 
                <select name=select>
                  <option>name</option>
                  <option>family</option>
                  <option>level</option>
                </select>
                <input type=submit name=Submit value=Sort />
              </div>
          </form>"
		  ?>

and

		echo "<form name=form1 method=get action='results.php?filter=$filter_Recordset1&search=$search_Recordset1&'
            <div align=center><span class=style12>Sort by</span> 
                <select name=select>
                  <option>name</option>
                  <option>family</option>
                  <option>level</option>
                </select>
                <input type=submit name=Submit value=Sort />
              </div>
          </form>"
		  ?>

Anyone else?

[bpat1434]

Read up on HTML forms. You aren't sending any values from the form into the URL. Each <option> tag needs to have a "value=''" parameter....

Plus, why not just use hidden fields:

<?php ?>
<form name='form1' method='get' action='results.php'>
	<input type='hidden' name='filter' value='<?php echo $filter_recordset1; ?>'>
	<input type='hidden' name='search' value='<?php echo $search_recordset1; ?>'>
	<select name='select' onChange='this.form.submit();'>
		<option value='name'>Name</option>
		<option value='family'>Family</option>
		<option value='level'>Level</option>
	</select>
	<input type='submit' value='Sort' name='submit'>
</form>

~Brett