...

View Full Version : selecting from the tables



saranya
04-10-2007, 12:49 PM
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.

Daemonspyre
04-10-2007, 02:28 PM
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?

saranya
04-10-2007, 03:03 PM
am using php/mysql .can u help me how to do this in javascript.

saranya
04-10-2007, 03:04 PM
am using php/mysql .can u help me how to do this in javascript.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum