PhotoPost Community - View Single Post - How do I turn off the "Pros" and "Cons" fields?

bob weaver · March 8th, 2008, 01:59 PM

Thanks. When a user adds a review, I have an extra field on the reviews input page called "Video link." The user can either type something in there or skip that and just give a rating and review. I assumed that the database would have a record of whether they typed in something to that field, or just left it blank. The "If" would be to check if that field was empty, for that product and that user.

It seems like that information is stored somewhere, because if they did type something into "Video link" then that text would have to be retrieved to display in that table in their review. So, it seems like if there is a way to retrieve the text they typed in that field, use the same way to merely check the text to see if the text exists and is not just null, or else check the length of it to see if it is longer than 0 characters, and if it is null or 0 characters, to just skip the table for it.

Maybe I'm not understanding how it stores what the user types in for a review. I assumed that everything the user types in for a review will go into the database somehwere, each field in one column or something.

March 8th, 2008, 01:59 PM	#9 (permalink)
bob weaver Member Verified Customer Join Date: May 2007 Posts: 58	Thanks. When a user adds a review, I have an extra field on the reviews input page called "Video link." The user can either type something in there or skip that and just give a rating and review. I assumed that the database would have a record of whether they typed in something to that field, or just left it blank. The "If" would be to check if that field was empty, for that product and that user. It seems like that information is stored somewhere, because if they did type something into "Video link" then that text would have to be retrieved to display in that table in their review. So, it seems like if there is a way to retrieve the text they typed in that field, use the same way to merely check the text to see if the text exists and is not just null, or else check the length of it to see if it is longer than 0 characters, and if it is null or 0 characters, to just skip the table for it. Maybe I'm not understanding how it stores what the user types in for a review. I assumed that everything the user types in for a review will go into the database somehwere, each field in one column or something. Last edited by bob weaver; March 8th, 2008 at 02:06 PM.