database query help
Posted: Mon Sep 12, 2011 6:17 am
[text]I am trying to access a value (number called userid) from database and display it in Textbox. This user ID should be depending on the name that customer select from a drop down box above the UserId textbox. The NAME that customer select is also from database.
Any one help me to write the WHERE statement and put that in textbox. Below is the code that I tried but got stuck.
[/text]
Any one help me to write the WHERE statement and put that in textbox. Below is the code that I tried but got stuck.
[/text]
Code: Select all
<td> Name </td>
<td> <select name="aname" id="aname" style="width: 147px">
<?php
$result = mysql_query("SELECT name FROM empdata where role='user' ORDER BY name ASC");
while ($row = mysql_fetch_array($result)) {
echo "<option>" . $row['name'] . "</option>";
}
?>
</select></td>
</tr>
<tr>
<td> ID </td>
<td colspan='3'> <input type="text" name="id" id="id"/>
<?php
$result = mysql_query("SELECT userid FROM empdata where name= ");
?>
</td>