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>