You will need Ajax for this.
Something like this:
Code:
<html>
<body>
<script type="text/javascript">
function ajaxFunc()
{
var ajaxRequest;
try
{
ajaxRequest = new XMLHttpRequest();
}
catch (e)
{
try
{
ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e)
{
return false;
}
}
}
return ajaxRequest;
}
function getData(user)
{
var request = ajaxFunc();
if (request == null)
{
return false;
}
request.onreadystatechange=function(){
if (request.readyState == 4)
{
var display = document.getElementById('data');
display.innerHTML = request.responseText;
}
}
request.open("GET","getuser.php?user="+user,true);
request.send(null);
}
</script>
<form>
<select name="list" id="list" size="5">
<option value="User1" onclick="getData(this.text);">User1</option>
<option value="User2" onclick="getData(this.text);">User2</option>
<option value="User3" onclick="getData(this.text);">User3</option>
<option value="User4" onclick="getData(this.text);">User4</option>
<option value="User5" onclick="getData(this.text);">User5</option>
</select>
</form>
<div id="data">Select a user from the list</div>
</body>
</html>
PHP Code:
<?php
$db['host'] = 'localhost';
$db['user'] = 'root';
$db['pass'] = 'root';
$db['dbname'] = 'ajaxtest';
$connect = @mysql_connect ($db['host'],$db['user'],$db['pass']);
$select = @mysql_select_db ($db['dbname'],$connect);
$user = $_GET['user'];
$user = mysql_real_escape_string (trim (strip_tags (htmlentities ($user))));
if (!empty ($user)) {
$sql = mysql_query ("SELECT * FROM users WHERE username='".$user."'");
if (mysql_num_rows ($sql) > 0) {
while ($row = mysql_fetch_array ($sql)) {
echo $row['username'].'<br />';
}
} else {
echo 'No user found';
}
}
?>