Hi,

I created a dynamic gallery from my SQL database. how can i ad comments to the images? Like in Facebook etc.

I think, it must work with the unique ID of the image, take that as foreign key fot the comments table.

I dont know, how to mix both :-(

Any ideas?
Denis

ps. maybe with an other extension?

Hello Denis,

You need to set an additional field in you table where the picture comments are which to contain an id to filter them. So each time someone adds a comment the id of the picture that comment is for to be set in that field.

Regards,

Hey Miro,

I got two tables:
IMAGES:
imageID
imageName
imageTitle
imageDescription

COMMENTS:
commentID
imageID
commentDate
commentText

If I want to do it with the Gallery, how does the comments change, if the image changes?

Denis

Quote

Hey Miro,

I got two tables:
IMAGES:
imageID
imageName
imageTitle
imageDescription

COMMENTS:
commentID
imageID
commentDate
commentText

If I want to do it with the Gallery, how does the comments change, if the image changes?

Denis

Hello Denis,

well.. that will be a bit tricky. You need to have a behavior on image change that to trigger an AJAX call to a server page where to get the comments for that paricular image and then populate the returned results. This will be the best way. There is another possibility - set up an iFrame where to show the comments and when image is changed to call a function that will call a page in that iFrame where the comments are filtered by image id.
But my opinion is that the AJAX is needed here.

Regards,

maybe it works Ajax DataGrid? and new comments with the lightbox?

Hello Denis,

well that can do the job... there is a behavior for filtering the Ajax DataGrid. about adding new comment .. well you can use whatever you like.

Regards,