Select Menus Query

[obrienkev]

Hi all,

I have created numerous select menus where the user can if they so wish select all or any one of them.

At the moment my code insists that they always select at least the subfund menu.

How can I set it up so that they can select any one menu?

Here's my code to date:

$query="select * 
  from subfund as s
inner
  join client as c
    on s.client_ID = c.client_ID
inner
  join director as d
    on s.director_ID = d.director_ID
inner
  join entity as e
    on s.entity_ID = e.entity_ID
inner
  join contact as co
    on s.contact_ID = co.contact_ID
inner
  join manager as m
    on s.manager_ID = m.manager_ID
inner
  join domicile as dm
    on s.domicile_ID = dm.domicile_ID
 where s.subfund = '$subfund'";

// Check what menus selected

if($client!="none") 
{
$query .=" and c.client='$client' and c.client_ID=s.client_ID";
}

if($director!="none") 
{
$query .=" and d.director='$director' and d.director_ID=s.director_ID";
}

[gardnc]

You've got to know to know no one here has a clue as to what you are asking.

[obrienkev]

OK. Basically I have 4 or 5 select menus.

The user can choose to select any of these menus.

How do I set my code up so that the user doesn't always have to select one certain menu?

At the moment my code requires the user to always select the subfund menu.

How do I fix my code to allow user to select any menu?

Hope this makes more sense.

Thanks,

Kevin.

[obrienkev]

Does this make sense?

Anyone help me please?

[gardnc]

Nope, try more detail information, such as how do they select a menu item?

Can you post the form and your entire action page?

[obrienkev]

Here are the select menus that the user chooses from.

<form action="two.php" name="form" method="post">
<span class="header">Select From the Below Menus:</span><br /><br />

<select name="subfund">
<option value="none">Select Subfund</option>
<?php
while ($row = mysql_fetch_array($result7))
{
echo "<option value='" . $row["subfund"] . "'>" . $row["subfund"] . "</option>";
}
?>
</select><br /><br />

<select name="directors">
<option value="none">Select Director</option>
<?php
while ($row = mysql_fetch_array($result))
{
echo "<option value='" . $row["director"] . "'>" . $row["director"] . "</option>";
}
?>
</select><br /><br />

<select name="clients">
<option value="none">Select Client</option>
<?php
while ($row = mysql_fetch_array($result2))
{
echo "<option value='" . $row["client"] . "'>" . $row["client"] . "</option>";
}
?>
</select><br /><br />
<input type="submit" name="submit" value="Continue" /><br /><br />
</form>

Then they taken to next page which displays results based on menus selected:

$query="select * 
  from subfund as s
inner
  join client as c
    on s.client_ID = c.client_ID
inner
  join director as d
    on s.director_ID = d.director_ID
inner
  join entity as e
    on s.entity_ID = e.entity_ID
inner
  join contact as co
    on s.contact_ID = co.contact_ID
inner
  join manager as m
    on s.manager_ID = m.manager_ID
inner
  join domicile as dm
    on s.domicile_ID = dm.domicile_ID
 where s.subfund = '$subfund'";

// Check what menus selected

if($client!="none") 
{
$query .=" and c.client='$client' and c.client_ID=s.client_ID";
}

if($director!="none") 
{
$query .=" and d.director='$director' and d.director_ID=s.director_ID";
}

At the start of this code "select * from subfund" requires the user to always choose from the subfund select menu.
I want the user to have the option of choosing from any one select menu.

How can this be done??

[obrienkev]

Can someone help me please??

[jansky]

something is missing when you submit your form

$post1=$POST['subfund'];
$post2=$POST['clients'];
$post3=$_POST['directors'];

then add this to your query // just an example
$query="select * from your query where subfund='$post1'";

[obrienkev]

Hi jansky,

What is that code to do? I have the variables set already:

$client = $_POST['clients'];
$director = $_POST['directors'];
$entity = $_POST['entity'];
$contact = $_POST['contacts'];
$manager = $_POST['manager'];
$domicile = $_POST['domicile'];
$subfund = $_POST['subfund'];

Each variable represents a select menu.
I want the user to be able to select any one menu.

[obrienkev]

Any ideas how to solve this?

Will PHP alone do it for me??

Thanks,

Kevin.