hello.
i'm working on a picture-gallery where the pictures are automaticly read from a directory.
optional there appears a info-text, which will be stored in a mysq-db.
if a picture is called "pets/cat01.jpg" and the same text should appear at "pets/cat02.jpg" i planned to set the path from the db to "pets/cat".
(with the possibility to set an extra infotext for 'pets/cat03.jpg', or an alternate text vor 'pets/'.)
if i am at the site where "pets/cat02.jpg" appears the best hit from db should now be shown.
but that doesnt work.
i'm working on a picture-gallery where the pictures are automaticly read from a directory.
optional there appears a info-text, which will be stored in a mysq-db.
if a picture is called "pets/cat01.jpg" and the same text should appear at "pets/cat02.jpg" i planned to set the path from the db to "pets/cat".
(with the possibility to set an extra infotext for 'pets/cat03.jpg', or an alternate text vor 'pets/'.)
if i am at the site where "pets/cat02.jpg" appears the best hit from db should now be shown.
select infotext from info where 'pets/cat02.jpg' LIKE path%but that doesnt work.
