How does menu/list box work?

[haans]

May I know how to code for:
I have a recordset= select * from table1;
and able to view all the records selected and displayed.

However to enhanced my code, I have added the sorting functionality. I allow user to sort by column A using a menu drop down box.

How do I code for the menu drop down box? This menu drop down box will have values like " Red/Blue/Green"

Eg: select colour from table1
where colour = 'RED';

So whenever user click on Red in the menu drop box, the page will refresh to displayed only records that are "RED". Currently all records are displayed irregardless of the colour.

Colour here is an example of a column.

Cheers.

[diego25]

So which part are you having trouble with? Creating the drop down menu, or getting the WHERE clause to work?

Diego

[haans]

I already know how to create the list box. It's more like coding on the selection.

[diego25]

So I assume your option box is like this:

<select name="colour">
<option value="red">Red</option>
</select>

So in your PHP you'd do:

$query = "SELECT * FROM table1";
if (isset($_REQUEST['colour'])) {
  $query .= " WHERE colour = '" . $_REQUEST['colour'] . "'";
}
mysql_query($query);

Diego

[haans]

I am using Dreamweaver to help me to code the list box.

Whenever I click on a selection in the list box, there is no response. Apparently the form variable is not passed to the page.

What am I suppose to enter in the "value" columns in the list box properties? I am using list values.

I have set my recordset having a condition based on the colour. I tested

$colname_Recordset1 = "BLUE"; ---- How can I allow my list box selection values to substitue the code here from "Blue" to any values I select from the list box.----

if (isset($HTTP_POST_VARS['colours'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['colours'] : addslashes($HTTP_POST_VARS['colours']);
}
mysql_select_db($database_mysql, $mysql);
$query_Recordset1 = sprintf("SELECT * FROM table1 WHERE category = '%s'", $colname_Recordset1);

Thanks.

[diego25]

How can I allow my list box selection values to substitue the code here from "Blue" to any values I select from the list box.

That's done in the following lines:
if (isset($HTTP_POST_VARS['colours'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['colours'] : addslashes($HTTP_POST_VARS['colours']);
}

Whenever I click on a selection in the list box, there is no response.

You forgot to add a submit button. You should click the submit button after selecting something in the listbox.

Diego

[haans]

I have actually changed to use jump box instead of list box which requires the GO button. Now i can see that the page is refreshing. However, I have problem with passing in parameter to the URL from my list box.

I can get this done using a text link. Eg:
<?php
echo("<p><a href='$PHP_SELF?colour=red'>".
"RED!</a></p>");
echo("<p><a href='$PHP_SELF?colour=blue'>".
"BLUE!</a></p>"); ?>

However, the code below for jump box doesn't work:
...........
<option value="<?php echo "<a href='$PHP_SELF?colour=red'>"; ?>">RED

<option value="<?php echo "<a href='$PHP_SELF?colour=blue'>"; ?>" >BLUE
</select>
<input type="submit" name="Button1" value="Go" onClick="MM_jumpMenuGo('menu2','parent',0)">
</p>

Cheers

[Weedpacket]

Originally posted by haans

<option value="<?php echo "<a href='$PHP_SELF?colour=red'>"; ?>">RED

If the value you want send back is "red", wouldn't the option's value be, well, "red"?

<option value="red">RED

Have have the <select> named "colour".

[haans]

Found a solution at last.

It's something like this:

<option value="<?php echo "$PHP_SELF?colour=red"; ?>">RED
....

But, I'm currently using GET as below:
if (isset($HTTP_GET_VARS['colours'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['colours'] : addslashes($HTTP_GET_VARS['colours']);
}

The moment I use http_post_vars, the whole thing doesn't work. Yes I understand that GET will allow me to pass in variable to URL.

So, if I use POST, what should my option value be? I won't be able to use echo $PHP_SELF?colour=red"

Please help

[diego25]

You don't need $PHP_SELF as part of your value; it should go in the action.

<option value="<?php echo "$PHP_SELF?colour=red"; ?>">RED

should just be

<form action="<?= $PHP_SELF ?>" method="post">
<select name="colour">
<option value="red">RED</option>

So, if I use POST, what should my option value be? I

You'd use $HTTP_POST_VARS (not $http_post_vars, remember PHP is case-sensitive) instead of $HTTP_GET_VARS.

Diego

[haans]

Well, it all works well if using your codes provided. Thanks.

But it required an additional "SUBMIT" button to make it worked.

Unless I use the jump list box as mentioned before, where the codes now becomes:
<select name="category" onChange="MM_jumpMenu('parent',this,0)" >

Notice the onChange="MM_jumpMenu......

However this doesn't work with HTTP_POST_VARS but with HTTP_GET_VARS.

Upon execution on the jump list box, I noticed the URL become
http://localhost/<value specified in option value>
ie eg: http://webserver/red

RED whereby I declare in my jump list box
option value="RED"

Hmm...I still need to figure this out. If not have to just add an additional "GO" button. :o

By the way, what would be the code like if I want to select all the records from my table? How should I code in
<option value=""> ??

Please help.

[diego25]

However this doesn't work with HTTP_POST_VARS but with HTTP_GET_VARS.

Upon execution on the jump list box, I noticed the URL become
http://localhost/<value specified in option value>
ie eg: http://webserver/red

Well, what does MM_jumpMenu() do?

By the way, what would be the code like if I want to select all the records from my table? How should I code in
<option value=""> ??

There is no built-in way to do that...You can do for example:
<option value="all">
and then in your PHP code you'd have
if ($color == "all") {
// select everything
}

Diego

[haans]

<select name="color" onChange="MM_jumpMenu('parent',this,0)" >

This statement of code is generated once I use the jump menu. By using the normal list box, it only shows:
<select name="color"

So I presume onChange="MM_jumpMenu('parent',this,0) is giving the problem.

[diego25]

Sorry, I don't understand your problem...

This statement of code is generated once I use the jump menu.

Shouldn't it be output to the browser before you use the menu?

By using the normal list box, it only shows:
<select name="color"

What's the "normal" listbox? You are using the regular one...There's nothing special about it...

Diego

[haans]

Sorry that I didn't explain clearly.

What I meant was that:
<select name="color" onChange="MM_jumpMenu('parent',this,0)" >

this line of code is generated thru Dreamweaver when I use the jump menu box.

There is another similiar function box known as list box in Dreamweaver performs the same function as the jump menu except that it requires a "SUBMIT" button.
So generally, one will get this code instead:
<select name="color">

Anyway, may I check with you if I am using HTTP_POST_VARS, can I code to use a list box which does not require me to have a "SUBMIT" button? So, whenever user click on the selection in the drop down box, it will pass in the value to the form, rather than being done in the "SUBMIT" button.

Thanks.

[Weedpacket]

If you want the form to submit when you change the value of the select, then the onChange code would be more like

onChange="this.form.submit()"

Not sure about the precise syntax of that, since I'm not that much into Javascript.