I have 2 tables. 1 is a client info table client_info and the other is domain_info. We lease websites to professional clients based on their areas of expertise. I'll use truck sales as an example. 1 client may lease websites on multiple domains for example: vintagepickups.com gmcworld.com world-o-trucks.com, etc all attached to a single id. In my online view of client_info I would like to display all of the domains assigned to his/her id in the domain_info table.
In phpmyadmin I can use
Code: Select all
SELECT `domain` FROM `domain_info` WHERE `lease_client` = '1260'
How would I do something similar for the described results for all clients?
Thanks in advance for any help / examples / tutorials you can send my way.
Bill