[PHP-DB] My SQL update one table, using reference from another...

I've been asked to add a field to a download capture sstem I've got. I've two tables, one that contains all the individual files info ('single_file'), and one that records the downloads ('completed_downloads'). All good... I've been asked to add a file_category (article, brochure, exe etc...) An

[PHP-DB] My SQL update one table, using reference from another...

I've been asked to add a field to a download capture sstem I've got. I've two tables, one that contains all the individual files info ('single_file'), and one that records the downloads ('completed_downloads'). All good... I've been asked to add a file_category (article, brochure, exe etc...) An