Ajax refresh/reload
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
<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>
ajax_search.php
<?
/* 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 } ?>

