Hi,
I have been searching the web for 2 days and I just can’t seem to find any answers or tutorials in relation to tables in phpMyAdmin.
Basically my question is very easy in that I simply have a table with around 5 photographer’s images in it. Each of these photographers has nearly 100 shots each and I need to pop in their email address once somebody clicks on a small thumb. Now as there is only 5 photographers I wanted to have the email addresses of these in a separate table so that I didn’t have to insert an email address into each individual field in the main table which would result in problems later on if some of these changes their email address for example.
So I’m so new to PHP and MySQL (only started looking at Christmas) I was wondering how to basically join tables in PhpMyAdmin i.e. can I use the phpMyAdmin panel to do this i.e. in Access for example I can join tables by dragging from one table to the other. I appreciate that PhpMyAdmin doesn’t have this kind of facility but maybe there is another way. I can’t see how to do this so any help would be most appreciated.
Thanks again
Brian
This is a plan of my tables
www.ahamay.com/sql.htm
Linear Mode
