sort list...

[crawfd]

I want a user to be able to redefine a query depending on what a user selects in a pull down menu. I'm not sure how to go about this, but I'm sure it's simple. Take the example below, ..should I define three queries and place them in seperate functions, and then place the function name in the value area? What is the best way to do this?

<form name="form1" method="post" action="">
<select name="select">
<option selected>Sort by</option>
<option value="Query One">Date</option>
<option value="Query Two">Gender</option>
<option value="Query Three">Last 30 Days</option>
</select>
</form>

[Weedpacket]

Put the name of the field to sort by in the option value, and then "order by ".$_POST['select']

Check first, of course, that $_POST['select'] is a legitimate field name that they can sort on.

[crawfd]

So place

order by ".$_POST['select']

in the query statement before the select form begins?

[cahva]

Do it something like this(dont put the query straight to select):

<form name="form1" method="post" action=""> 
<select name="select"> 
<option selected>Sort by</option> 
<option value="1">Date</option> 
<option value="2">Gender</option> 
<option value="3">Last 30 Days</option> 
</select> 
</form>

<?php
$query="SELECT * FROM table ";
switch($_POST['select']) {
	case 1:
	$query.="ORDER by date";
	break;

case 2:
$query.="ORDER by gender";
break;

case 3:
$query.="WHERE timefield > DATE_SUB(NOW(), INTERVAL 30 DAY)ORDER by date";
break;
}

$result=mysql_query($query);
while ($row=mysql_fetch_array($result)) {
	// Do your stuff
}
?>

[crawfd]

Okay so now I have the following, but it seems the form isn't posting, and I'm getting a browser error or some sort

$query = mysql_query("Select * FROM $table WHERE username = '".$_SESSION['username']."' order by '".$_POST['sort']."' DESC",$db);

$p .= "<select name=\"sort\" style=\"font-size: 11px; font-weight: bold; color: #000000;\" onChange='top.location.href=this.form.sort.options[this.form.sort.selectedIndex].value'>
  <option value=\"$date\">Date</option>
  <option value=\"$awareness\">Awareness</option>
  <option value=\"$dreamstatus\">Recent</option>
  <option value=\"$dreamstatus\">Past</option>
  </select></form>";

echo $p;

[crawfd]

I tried the following but nothing is happening on post? Is there something wrong with the javascript?

$selectmenu .=  "<select name=\"sort\" style=\"font-size: 11px; font-weight: bold; color: 000000;\" onChange=\'top.location.href=this.form.sort.options[this.form.sort.selectedIndex].value\'>
        <option value=\"1\">Date</option>
        <option value=\"2\">Awareness</option>
        <option value=\"3\">Past Recent</option>
        </select></form>";

echo $selectmenu;

$query = mysql_query("Select * FROM $table WHERE username = '".$_SESSION['username']."' order by '".$_POST['sort']."' DESC",$db);

switch($_POST['sort']) { 

   case 1: 
    $query.="ORDER by date"; 
    break; 

case 2: 
$query.="ORDER by awareness"; 
break; 

case 3: 
$query.="ORDER by dreamstatus"; 
break; 

} 

[crawfd]

Added a form name (that helped) but when I select a list menu option it redirects to another page with values 1,2,3 instead of selecting the case for the query below??

$selectmenu .=  "<form name=\"\"><select name=\"sort\" style=\"font-size: 11px; font-weight: bold; color: 000000;\" onChange='top.location.href=this.form.sort.options[this.form.sort.selectedIndex].value'>
        <option value=\"1\">Date</option>
        <option value=\"2\">Awareness</option>
        <option value=\"3\">Past Recent</option>
		</select></form>";
		echo $selectmenu;

$query = mysql_query("Select * FROM $table WHERE username = '".$_SESSION['username']."' order by '".$_POST['sort']."' DESC",$db);

switch($_POST['sort']) { 

case 1: 
$query.="ORDER by date"; 
break; 

case 2: 
$query.="ORDER by awareness"; 
break; 

case 3: 
$query.="ORDER by dreamstatus"; 
break; 
} 

[sidney]

<form name="form2" method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">

<select name="sort" onchange="document.forms['form2'].submit()">

[cahva]

Sidney put something for you allready but I will put mine here also.. You had things in wrong order and also insufficient form information.

$selectmenu .=  '<form name="sort" action="page.php" method="POST"><select name="sort" style="font-size: 11px; font-weight: bold; color: 000000;" onChange="javascript:document.sort.submit()"> 
        <option value="1">Date</option> 
        <option value="2">Awareness</option> 
        <option value="3">Past Recent</option> 
        </select></form>'; 
        echo $selectmenu;

$query="Select * FROM $table WHERE username = '".$_SESSION['username']."'";

switch($_POST['sort']) {  

case 1:  
$query.=" ORDER by date";  
break;  

case 2:  
$query.=" ORDER by awareness";  
break;  

case 3:  
$query.=" ORDER by dreamstatus";  
break;  
}

$result = mysql_query($query,$db);

[crawfd]

Cahva, that doesn't seem to work. I revised the script below, ..but now I get a invalid MySQL result error after selecting a criteria from the pull down list

$selectmenu .=  "<form name=\"form2\" method=\"post\" action=\"home.php?page=manage\"><select name=\"sort\" onchange=\"document.forms['form2'].submit()\"> 
        <option value=\"1\">Sort by Date</option> 
        <option value=\"2\">Sort by Awareness</option> 
        <option value=\"3\">Sort by Past/Recent</option> 
        </select></form>"; 
        echo $selectmenu; 

$query = "Select * FROM $table WHERE username = '".$_SESSION['username']."'"; 

switch($_POST['sort']) {  

case 1:  
$query.="ORDER by date";  
break;  

case 2:  
$query.="ORDER by awareness";  
break;  

case 3:  
$query.="ORDER by dreamstatus";  
break;  
}
$result = mysql_query($query,$db);

	$p .= "<table align=\"center\" width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\" class=\"table_border\">\n";
	$p .= "<tr class=\"header_cell\">";
	$p .= "<td>Date</td><td>Title</td><td>Past or Recent</td><td>Awareness</td><td>Modify</td><td>Delete</td></tr>\n";
	echo $p;
while(list($id,$date,$username,$title,$dreamstatus,$entry,$awareness,$pagination) = mysql_fetch_row($query)){
	$d = explode("-",$date);
	$titletrimmed = substr($title, 0, 20);
	$thedate = "$d[2]/$d[1]/$d[0]";
	$print  = "\n<tr class=\"cells\">\n";
	$print .= "<td><li>$date</td><td><b>$titletrimmed...</b></td>\n";
	$print .= "<td>$dreamstatus</td>";
	$print .= "<td>$awareness</td>";
	$print .= "<td align=\"center\"><a href=\"home.php?page=manage&action=modify&entry=$id\">";
	$print .= "Modify</a></td>\n";
	$print .= "<td align=\"center\"><a href=\"home.php?page=manage&action=remove&entry=$id\">";
	$print .= "Delete</a></td>\n";
	$print .= "</tr>\n";
	echo $print;
}
echo"</table><br></center>";
} 

[sidney]

your query looks like this
Select * FROM $table WHERE username = 'some name'ORDER by date

need a space before orderby

and is $table set

 $query = "Select * FROM $table WHERE username = '".$_SESSION['username']."'";  

switch($_POST['sort']) {   

case 1:   
$query.=" ORDER by date";   
break;   

case 2:   
$query.=" ORDER by awareness";   
break;   

case 3:   
$query.=" ORDER by dreamstatus";   
break;   
} 

[crawfd]

Sid, I added the spaces, still get a query error (supposedly right below $result = mysql_query($query,$db); somewhere). The variable $table is set yes.

$selectmenu .=  "<form name=\"form2\" method=\"post\" action=\"home.php?page=manage\"><select name=\"sort\" onchange=\"document.forms['form2'].submit()\"> 
        <option value=\"1\">Sort by Date</option> 
        <option value=\"2\">Sort by Awareness</option> 
        <option value=\"3\">Sort by Past/Recent</option> 
        </select></form>"; 
        echo $selectmenu; 

$query = "Select * FROM $table WHERE username = '".$_SESSION['username']."'";

switch($_POST['sort']) {  

case 1:  
$query.=" ORDER by date";  
break;  

case 2:  
$query.=" ORDER by awareness";  
break;  

case 3:  
$query.=" ORDER by dreamstatus";  
break;  
}
$result = mysql_query($query,$db);

	$p .= "<table align=\"center\" width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\" class=\"table_border\">\n";
	$p .= "<tr class=\"header_cell\">";
	$p .= "<td>Date</td><td>Title</td><td>Past or Recent</td><td>Awareness</td><td>Modify</td><td>Delete</td></tr>\n";
	echo $p;
while(list($id,$date,$username,$title,$dreamstatus,$entry,$awareness,$pagination) = mysql_fetch_row($query)){
	$d = explode("-",$date);
	$titletrimmed = substr($title, 0, 20);
	$thedate = "$d[2]/$d[1]/$d[0]";
	$print  = "\n<tr class=\"cells\">\n";
	$print .= "<td><li>$date</td><td><b>$titletrimmed...</b></td>\n";
	$print .= "<td>$dreamstatus</td>";
	$print .= "<td>$awareness</td>";
	$print .= "<td align=\"center\"><a href=\"home.php?page=manage&action=modify&entry=$id\">";
	$print .= "Modify</a></td>\n";
	$print .= "<td align=\"center\"><a href=\"home.php?page=manage&action=remove&entry=$id\">";
	$print .= "Delete</a></td>\n";
	$print .= "</tr>\n";
	echo $print;
}
echo"</table><br></center>";
} 

[sidney]

add an echo below switch and tell us what the output for line is

echo $query;

[crawfd]

The echo below the case portion returns this result of the query:

Select * FROM entries WHERE username = 'crawfd' ORDER by awareness

That's when I selected awarenss from the pull down list.
The case funtion seems to be alterning the query, but the rows aren't showing...

[sidney]

that looks correct the echo was a test to see if query had been constructed right a way to debug

just check the spelling and upper and lower case of all those field and table name and see if they match your table

[sidney]

should be

mysql_fetch_row($result)){

not

mysql_fetch_row($query)){

[crawfd]

figured it out.........

I had

while(list($id,$date,$username,$title,$dreamstatu
s,$entry,$awareness,$pagination) = mysql_fetch_row($query)){ 

changed it too

while(list($id,$date,$username,$title,$dreamstatu
s,$entry,$awareness,$pagination) = mysql_fetch_row($result)){ 

[crawfd]

Good timing (but I was 1 second faster) hahahaha j/k

[sidney]

no you werent you were a minute slower

but who gives a rat's arse any way lol