Hi folks,
I'm trying to search for a link in multiple tables in my database and update that link on the web form at once if found. I have trouble with the logic of running through all the tables to find and display it on the form. Would you please guide me how to do it!
table 1:
field name data
*****************************
bookType history
location aaa
bookName American history
id 1
link
http://www.yahoo.com
table 2:
/////////////////////////////////////////////////
field name data
******************************************
bookType history
location bbbbb
bookName Mexican history
id 2
link
http://www.yahoo.com
/////////////////////////////////////////////////////////////////////
Thanks so much
td