how to refresh data with selection made in dropdown menu

Hi

I made a form that puts data in the dbase. That all works fine. What i now want is that i have a form,that has a dropdown menu which if i select an option the form display in a table data from the dbase. I'v looked in the forms but i just didn't found a good example that'sclear for me.

Can somebody help me on the with an example how to fill in this ?

greets
Stefan

Hi Stefan,

ChronoConnectivity is designed to do this.

Bob

Hi, i know, i installed it. But don't really know how to make it work, I looking for some example code to give me an idea

Hi Stefan,

See some initial tutorials here. More to follow when I get time to write them.

Bob

i bought the manual, but still i can't get it to work.
I have put my code in here. I want a form that gives the selection of different sportsgames. This works. it display the choices. It gets them from another field from the dbase. What i want is that i select a sportsgame and press on submits it displays the users who have subscribed to this sports game. the sportsgames are having 2 fields in the dbase to see which they are. first field is : 'wedstrijd'. This is the name of the sportsgame. the second is a wedstrijd_id. Which is a number. One of them can be used to make the selection.

WHERE :
<?php
$wedstrijd = JRequest::getInt('wedstrijd', '', 'post');
if ( $wedstrijd > 0 ) {
echo " WHERE `wedstrijd` = '$wedstrijd' ";
}
?>

----------------------------------------------------------------------------------------
HEADER :

<div class="form_item">
<div class="form_element cf_text"> <span class="cf_text">Actuele inschrijvingen RKHAV atleten</span> </div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_text"> <span class="cf_text"></span> </div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Wedstrijd :</label>
<select class="cf_inputbox validate-selection" id="select_2" size="1" title="selecteer wedstrijd" name="wedstrijd">
<option value="2">selecteer wedstrijd</option>

<?php

$sql= mysql_query("SELECT * FROM wedstrijden")or die(mysql_error());
$nSql = mysql_num_rows($sql);

if($nSql > 0){

while($fSql = mysql_fetch_assoc($sql)){

echo '<option value="'.$fSql['wedstrijden_id'].'">'.$fSql['wedstrijdnaam'].'</option>';

}

}

?>

</select>
</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_text"> <span class="cf_text"></span> </div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_button">
<input value="bekijk inschrijvingen" name="button_1" type="submit" />
</div>
<div class="cfclear"> </div>
</div>

----------------------------------------------------------------------------------------
BODY :


<table style="text-align: left; width: 100%;" border="1" cellpadding="2" cellspacing="0">

<STYLE TYPE="text/css">
<!--
TD{font-size: 7pt;}
--->
</STYLE>


<tr><td>
{naam}<td>{licentienummer}<td>{geboortejaar}<td>{geslacht}<td>{categorie}<td>{startnummer}<td>{onderdeel1}<td>{pronderdeel1}<td>{onderdeel2}<td>{pronderdeel2}<td>{onderdeel3}<td>{pronderdeel3}<td>{onderdeel4}<td>{pronderdeel4}
<td><tr></table>

<td>

Hi stefandeblock ,

Please don't double post - I've just replied to a very similar post in another thread.

Bob