studioeightyone

Thanks Josh.... I've changed it to the 3 tables now... Taking a wild guess at what should be in each but my main question at the moment is how in php do i show a pdf related to 1 of the keywords? I'm pretty new to php... i'm 3 weeks into a 12 week php introduction course... and we've not covered this stuff yet... Hope you're enjoying your weekend.. Stu

Hi everyone, first post on the forum, so sorry if I've missed anything... I've been doing small bits of php/msql recently and I'm trying to write some code that will display a pdf or jpg that has certain keywords associated with it. I've created a table and added 4 fields/columns. ID, filename, thumbnail, keywords How can I get php to display a PDF/JPG that has a certain keyword associated with it? so... say I had 10 different animal pictures, and I wanted to see the dog picture and the dog picture had 'brown' and 'dog' as keywords in the database how and what would the code look like to display this on a webpage search? Hope I'm making sense Stu