Selecting MySQL variable value, that depends to other value

[Erica McLane]

How to do this? I have a table, simmilar to this:

 

Tablename Test.

 

ID | Title | Text

1 | One | Test1

2 | Two | Test2

3 | Three | Test3

4 | Four | Test4

5 | Five | Test5

 

I filled one drop-down listbox with the values in Title. Now I need this - the script should display the \'Text\' value, depending on the selected \'Title\' in the SAME PAGE, when the user selects the \'Title\" in the listbox. Is there a way to do this?

Thanks in advance!

 

Example: There is a listbox and the user selects \'Two\'. Now the script should display \"Test2\".

[wompus]

This would be your drop-down

<input name="something">

 

This would be your php

[php:1:9d98bc23a5]
$query = \"SELECT * FROM tablename WHERE Title = $something\";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo($row[\'Text\']);
}


?>[/php:1:9d98bc23a5][/code]