drop-down lists

Anon

I have a problem with drop down lists and her is the scenario.

I want to create a drop-down list with names of persons in a database. When one person is chosen, I want info about him to appear on the right of the same side. I want the info to appear without having to submit by pressing a button. I want it to be shown automaticaly when choosing a person. My code looks someting like this:

<p><font color="FFFFFF"face="Arial">
All users:
<select size=1 name="usernamn">
<OPTION SELECTED VALUE="">Choose a person
<OPTION VALUE="">-------------
<?php
$user=mysql_query("SELECT FROM Users");
while($person=mysql_fetch_array($user)){
$usename=$person["username"];
$Namn=$person["name"];
echo("<OPTION VALUE='$usename'>$Namn\n");
}
?>
</SELECT></p>
</td>
<?php
$chosen=mysql_query("SELECT FROM Users WHERE username=$usename");
while ($chosenperson=mysql_fetch_array($chosen)){
?>

  <td width="196" height="39">
      <p><font color="#FFFFFF" face="Arial"><label for="fp1">Name:</label><input type="text" name="name" value="<?php echo($chosenperson["name"]);?>" size="20"></font></p>
  </td>

Anon

This can (and has to) be done with Javascript, PHP can't (won't) do anything until you submit the info, JS will do things on rollovers or whatever.
I can't help you much from here (school) as most of my scripts are at home, but if you can't find the code I'll paste it here in 3 hours when I get back.

www.hotscripts.com is your best bet

Its just some simple (20 lines or so) code you put between the <head> </head> tags and then a tiny alteration to the query you have above.

Incidently..

<select size=1 name="username"> 😛

(might solve some problems later on if you try to retrieve the variable $username and get nothing.

Anon

Yes please, send me the java script code!!

So if I understand you right I can't get the info without pressing a button. Isn't there any way to reload the page automaticly with PHP when I choose a name in the drop-down menu.

tx a lot Fred

jc94062

correct, I can't think of the correct term off hand, ones server side, ones not, PHP won't do anything until you submit it.

Okay, I've pasted the code I have got below, it will need to be modified.

Currently its just one member in a list and when you click on their name it sends you to the URL specified by the value.

<head>
<title>Enter Title</title>
</head>
<SCRIPT LANGUAGE="JavaScript">
function formHandler1(){
var URL = document.form1.site.options
[document.form1.site.selectedIndex].value;
window.location.href = URL;
}
</SCRIPT>
<body>

<table bgcolor="342d7e" width ="600" height="50" align="center" cellspacing="1">
<tr>
<td align="center" width=200>
<font color="87f717">Select Member</font>
<FORM name = "form1">
<SELECT NAME="name" SIZE=1 onChange ="formHandler1()">
<OPTION VALUE="http://www.mysite.com/name.htm">Member 1</SELECT></FORM>
</td>
</tr>
</table>
</body>

Hope it helps!