fetching database value depending on textbox condition

[naveendk.55]

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.

 

 

<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>

[Muddy_Funster]

couple of things - 1 this screams of "homework assignment" and  -2 a table isn't a textbox, so what are you supposed to be using?

[naveendk.55]

I have assigned a unique number for each Name in database.  I want to display the unique number depending on the name selected in below textbox.

[fenway]

Well, you might want to use $result somehow.

[naveendk.55]

I don't mind any way getting it done. Please let me know if any of you have any information. It is an urgent task. Thank U.

[fenway]

There are no such things are "urgent tasks" on free forums.

 

Are you familiar with mysql_query()?

[naveendk.55]

Yes, I'm know about mysql_query(). But not how to access data for this particular issue.

[fenway]

You're in the wrong forum.  You're asking about how to make another request to the server from a client-side value -- that's what AJAX is all about.

 

Though I suppose if it's a really small list, you can do it all in JS.

[naveendk.55]

Thanks