Topic: Set image title to albumname (Read 1949 times)

grrrrr · « **on:** June 06, 2009, 03:07:47 pm »

Is there an easy way to set the "image title" attribute in my database to the "albumname"?
either by hand, everytime i add new picturesvia an sql-script, or automatically for now and ever?

grrrrr · « **Reply #1 on:** June 06, 2009, 04:05:41 pm »

by hand:

Code: [Select]

UPDATE coppermine_pictures cp 
JOIN coppermine_albums ca ON ( cp.aid = ca.aid ) 

SET cp.title = ca.title

News:

Author Topic: Set image title to albumname (Read 1949 times)

grrrrr

Set image title to albumname

grrrrr

Re: Set image title to albumname