Adobe Community: List menu using dynamic fields

Currently Being Moderated

1. bregent,

Jul 26, 2012 10:07 AM in reply to ant01

Report

>I want the initial entry to be blank but the populated field adds the first

>entry of the table in the drop down list, how do I remove this and show intial value as blank.

You create the initial default item first, before looping through the recordset to populate the rest of the values.

>With the code below the user has to fill in all the search items as I am using AND in the WHERE clause.

The best way to handle this is to build your WHERE clause dynamically. That is, evaluate the fields passed from the form and if they are empty, do not include that criteria in the WHERE clause. You will need to code this by hand as DW doesn't handle this scenario.

|

Mark as:

Currently Being Moderated

2. ant01,

Jul 26, 2012 11:21 AM in reply to bregent

Report

Hi bregent

Thanks again for the help. Please can you give me an example of the code The full code of the search and results page is on the post http://forums.adobe.com/message/4581526#4581526 below is a summary of the results code created by dreamweaver;

if (isset($_POST['delegates'])) {

$varDel_results = $_POST['delegates'];

}

$varProv_results = "-1";

if (isset($_POST['province'])) {

$varProv_results = $_POST['province'];

}

$varCat_results = "-1";

if (isset($_POST['category'])) {

$varCat_results = $_POST['category'];

}

mysql_select_db($database_tova, $tova);

$query_results = sprintf("SELECT wp_dbt_venues.venuesID, wp_dbt_venues.name, wp_dbt_venues.category, wp_dbt_venues.province, wp_dbt_venues.city, wp_dbt_province.provinceID, wp_dbt_province.province, wp_dbt_conferencefacilties.venueid, wp_dbt_conferencefacilties.maxcapacity FROM ((wp_dbt_venues LEFT OUTER JOIN wp_dbt_province ON wp_dbt_venues.province = wp_dbt_province.provinceID) LEFT OUTER JOIN wp_dbt_conferencefacilties ON wp_dbt_venues.venuesID = wp_dbt_conferencefacilties.venueid) WHERE wp_dbt_venues.category = %s AND wp_dbt_venues.province = %s AND wp_dbt_conferencefacilties.maxcapacity < %s", GetSQLValueString($varCat_results, "text"),GetSQLValueString($varProv_results, "int"),GetSQLValueString($varDel_results, "int"));

$results = mysql_query($query_results, $tova) or die(mysql_error());

$row_results = mysql_fetch_assoc($results);

$totalRows_results = mysql_num_rows($results);

|

Mark as:

Currently Being Moderated

3. ant01,

Jul 31, 2012 2:56 AM in reply to ant01

Report

Please can someone help me with an example of this coding, I'm really struggling...

|

Mark as:

Currently Being Moderated

4. dunnmaks,

Jul 31, 2012 12:00 PM in reply to ant01

Report

You would be better off building you query in pieces. I.e.

$and = (isset($_POST['province'])) ? " AND wp_dbt_venues.province = '".$_POST['province']."'" : NULL;

$and .= (isset($_POST['category'])) ? " AND wp_dbt_venues.category = '".$_POST['category']."'" : NULL;

Then when displaying do this:

<?php #loop over results { ?>

<option value="id">Whatever</option>

<?php } ?>

</select>

|

Mark as:

Develop server-side applications in Dreamweaver

List menu using dynamic fields

Jul 26, 2012 7:02 AM

More Like This

Bookmarked By (0)

Answers + Points = Status