insert tabel in mysql

[landuyt]

Hi,

im not an expert on mysql,...

but here is my problem

i want an extra table in idx_links ( thumbshot )

i have a map with all the thumbshots of the sites listed in my directory.
(www.mysite.come/thumbs )

the names of the jpg's are all idnumber.jpg

i want an extra table in my id_links with the names of these pics.
so in id number 12345 must be a table with 12345.jpg

is it possible to do this automaticly? because typing 9500 names of pics


from there i could do some extra stuff with the thumbshots.

greetings peter

[inspireme]

I maybe missing something but this is jsut your ID column with .jpg put on the end, What do you need this column for exactly?

[landuyt]

yes indeed... i want an extra colum with the jpeg names ( not the files itself, but idnumber.jpeg on the exact row of that idnumber )
but i don't know how to do it or if it is even possible.

the files (pics) itself must stay in a specific map. otherwise the database becomes to big.

i think i can do some extra stuff with my pics then when they are in the database. ( search pics only, pic gallery with links to detail page, browse only with pics in the categories and even rewrite the names of the pics to namesite.jpg ( search engines !....etc )

But it's just an idea i have. maybe there are easyer ways to do some nice things with the thumbs.

greetings peter.

[inspireme]

Good ideas, I was thinking about doing what you have with the gallery, I planned to use the title tag on the images as the <%title%>, but as you say the ID.jpg format is not the most SEO friendly. It would need a php script to read the database titles, then load corresponding image ID, rename it to the tile, then write to the DB... It can be done, although with my limited skills a fairly big job.

Ps. what gallery program did you use for the thumbs?

matt

[inspireme]

Ok i made some improvments :

1) You can generate the list of IDS for all images added in the last Day/Week/Month. Allowing smaller updates to the thumbs without having to do the whole lot!

2) Im looking into creating the php script to make the images SEO friendly - it will help you on google images AND on the main listing as you will have relevantly named images.

I have point (1) done so send me an email if you want that. Im working on point (2) but Im pretty busy at the moment so dont expect it quickly!!!!

[landuyt]

thx ! send you a mail.

[inspireme]

OK I did all of that, but its imprtant to note if a user modifies the title of the listing the image name will no longer relate to it, and cause a broken image... not a big issue as it will be sorted on the next thumbs update you do, especially if you have a "awaiting image" notice which will display instead

Email me if you want it.

[landuyt]

You are God !

this works perfect. it took me 5 seconds to rename the 9500 pics

thx again

peter
audiomastermind

Now google can come with there army of image bots.