PhotoPost Community - View Single Post - NOT have assigned to additional cats pics duplicated in thumb filmstrip

Bill Thebert · November 23rd, 2005, 03:16 PM

Thanks for jumping back in on this, Chuck.

Just to be *really* explicit, you're saying I need to change, for example, lines 186 & 187 from:

Code:

Content visible to verified customers only.

to

Code:

Content visible to verified customers only.

Is this correct?

And that I need to make similar changes somewhere in php-inc.php?

Here's function display_gallery. It appears to this novice to contain several "queries" -- many of which already include the phrase "AND storecat=0" (*without* the single quotes around the zero).

Code:

Content visible to verified customers only.

Please forgive my ignorance, but I'm still not exactly clear what you're telling me to change here. I could use *explicit* direction.

And if I do this, will this change at all the fact that the photo count in the statistics is artificially doubled? Or the fact that I have to double & triple maintain the database when I alter/edit a description of a photo that is filed in two categories? Will folks be able to comment on ONE photo, and have that comment appear in all three categories under which that photo appears?

I think I'm asking about a big-picture, database-design question. One that probably can't be solved with a simple edit here or there.

I think what I'm asking about revolves around the fact that there are duplicate lines/records created in the 'photos' table whenever an image is cataloged in multiple categories. Wouldn't it be wiser (and better "normalized" in dbm lingo) to have just ONE record for each photo?

November 23rd, 2005, 03:16 PM	#9 (permalink)
Bill Thebert Member Join Date: Nov 2001 Posts: 66	Thanks for jumping back in on this, Chuck. Just to be really explicit, you're saying I need to change, for example, lines 186 & 187 from: Code: Content visible to verified customers only. to Code: Content visible to verified customers only. Is this correct? And that I need to make similar changes somewhere in php-inc.php? Here's function display_gallery. It appears to this novice to contain several "queries" -- many of which already include the phrase "AND storecat=0" (without the single quotes around the zero). Code: Content visible to verified customers only. Please forgive my ignorance, but I'm still not exactly clear what you're telling me to change here. I could use explicit direction. And if I do this, will this change at all the fact that the photo count in the statistics is artificially doubled? Or the fact that I have to double & triple maintain the database when I alter/edit a description of a photo that is filed in two categories? Will folks be able to comment on ONE photo, and have that comment appear in all three categories under which that photo appears? I think I'm asking about a big-picture, database-design question. One that probably can't be solved with a simple edit here or there. I think what I'm asking about revolves around the fact that there are duplicate lines/records created in the 'photos' table whenever an image is cataloged in multiple categories. Wouldn't it be wiser (and better "normalized" in dbm lingo) to have just ONE record for each photo? Last edited by Bill Thebert; November 23rd, 2005 at 03:22 PM.