drop down box

[christophe]

Hi there,

Right O.K I have this code

[code]

include_once("includes/config.php");

$query="SELECT letter,id,word,description FROM dictionary";

$result = mysql_query ($query);
echo "<select name=word=''">Word</option>";

while($nt=mysql_fetch_array($result)){
echo "<option value=$nt[id]>$nt[word]</option>";

}
echo "</select>";

?>

[/code]

so my question:

how do i make this script so when a user selects an option from the drop down box it pulls information from the description field in my database and displays this information on the same page?



ive been stuck on this for ages now so any help will be much appreciated

Thanks
Alex

[PHPSpirit]

[quote author=christophe link=topic=116568.msg475026#msg475026 date=1164713206]
Hi there,

Right O.K I have this code

[code]

include_once("includes/config.php");

$query="SELECT letter,id,word,description FROM dictionary";

$result = mysql_query ($query);
echo "<select name=word=''">Word</option>";

while($nt=mysql_fetch_array($result)){
echo "<option value=$nt[id]>$nt[word]</option>";

}
echo "</select>";

?>

[/code]

so my question:

how do i make this script so when a user selects an option from the drop down box it pulls information from the description field in my database and displays this information on the same page?



ive been stuck on this for ages now so any help will be much appreciated

Thanks
Alex
[/quote]


You need use AJAX.

http://www.w3schools.com/ajax/default.asp