Forum Moderators: coopster
1. Files (file_id PK, file_name, file_desc, file_pages)
2. Tags (tag_id PK, tag)
3. Tags2Files (tag_id, file_id)
I have to enter tags by hand (into Tags but, to save keystrokes, for the filenames I have a routine that opens a directory and adds any new files into Files.
What's stumping me: Files which have not been tagged. So far, I have a query that retreives all untagged files to a php array. I want to step through the array, record by record, in each case feeding the filename to another page where tags and a description will be added, then returning to the array for the next file name until all untagged files have been tagged.
Is this an inefficient foreach loop situation? If so, how do I signify to the "foreach" that tags have been added when I POST them, so the loop provides me with the next untagged file name from the array of untagged files. Hope this makes sense. Thanks!