Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    selecting from the tables

    hello,
    i have two tables table1 contain techid,techname and table2 contains userid,username,techid.
    in my webpage i displayed two combo boxes.one contains the techname(s) if i click one of the techname i want to get the usernames corresponding to the techname to display in the another combo box. by accessing the techid.

    if any one knows the select query please help me.

  • #2
    Regular Coder
    Join Date
    Mar 2007
    Posts
    505
    Thanks
    1
    Thanked 19 Times in 19 Posts
    This would be done using either PHP or ASP/ASP.NET AND/OR AJAX.

    It would involve 2 SQL queries, one to be done to pull the technames, then after a javascript: onchange() or javascript: onclick(), a second SQL query to pull the usernames.

    What server-side scripting language are you using?

  • #3
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    selecting from the tables

    am using php/mysql .can u help me how to do this in javascript.

  • #4
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    am using php/mysql .can u help me how to do this in javascript.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •