Im pretty ok with PHP and have recently been breaking down a project using foreign keys to identify various bits of information.
This is my problem.
I have an items table, which is made up of ID, country and area.
It previously has the actual word of the country and area.
I have broken it down so it now the id from the country table.
What i want to know how to do is when i request that item to be listed, i want it to reference the country table to find the name, as at present it just shows the number.
Please can somebody give me an example? Even just a small one.
This aint homework! its 10am on a monday morning :-/