My main question i think is, how, when i call the dhtmlgoodies script, can i get the div/page to show using the newest variable? Here is some stripped out important code.
index.php
Expand|Select|Wrap|Line Numbers
- <select id="sale_type_id" name="sale_type_id" onmousedown="ajax_loadContent('search','ajax_search_blank.php');" onchange="makeRequest('ajax_search.php?sti=',this.value);ajax_loadContent('search','ajax_search.php');">
- <? $_stt = db_query("SELECT sale_type_id, sale_type_name FROM sale_type WHERE sale_type_id <> 43 ORDER BY sale_type_name ASC");
- while($stt = db_fetch_array($_stt)) { ?>
- <option value="<?php pv($stt['sale_type_id']); ?>"><?php pv($stt['sale_type_name']); ?></option>
- <? } ?>
- </select>
- <p>
- <DIV id="search"></DIV>
Expand|Select|Wrap|Line Numbers
- <?
- /* set the sale_type id for the search drop down. */
- if(isset($_GET['sti'])) {
- $_SESSION['sti'] = $_GET['sti'];
- }elseif(isset($_SESSION['sti'])) {
- $_stt = db_query("
- Select distinct
- sale_type_field.sale_type_field_name,
- sale_type_field.sale_type_field_id
- From
- sale_type_field
- JOIN connector_sale_type_field ON sale_type_field.sale_type_field_id = connector_sale_type_field.sale_type_field_id
- Where
- connector_sale_type_field.sale_type_id = '".$_SESSION['sti']."'
- ORDER BY
- sale_type_field.sale_type_field_name ASC
- ");
- while($stt = db_fetch_array($_stt)) {
- $sale_type_field_id[] = $stt['sale_type_field_id'];
- $sale_type_field_name[] = $stt['sale_type_field_name'];
- } ?>
- <select name="search_field[]">
- <option value=""></option>
- <option value="sale_id">Sale Id</option>
- <?php for ($j = 0; $j < count($sale_type_field_name); $j++) { ?>
- <option value="<?php pv($sale_type_field_id[$j]); ?>"><?php pv($sale_type_field_name[$j]); ?></option>
- <?php } ?>
- </select>
- <?php } ?>