Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Edding Pictures and quering Database...

Dec 22, 2003, 11:18 PM

dbode

Novice (9 posts)

Dec 22, 2003, 11:18 PM

Post #1 of 4

Shortcut

Edding Pictures and quering Database...

Hi !

I use LinksSQL now for two years and we have a lot of links inside. Now, I want to use it for more features on our site, but I need to know if this is possible :

I want to use another URL, where I can store Images in (like the Plugin available), but I also need the URL that is used now. So it should look like :

THIS IS THE LINK TITLE
Link description like always
URL to the Link

Of course, the picture should dissapear if there is no URL

Then I want to call some links out of categories on a front page (the latest 10 for example). Is this possible ?

Thanks for your help,

Dennis

Dec 23, 2003, 2:47 AM

Andy

Veteran / Moderator (18441 posts)

Dec 23, 2003, 2:47 AM

Post #2 of 4

Shortcut

Re: [dbode] Edding Pictures and quering Database... In reply to

Pretty simple if I understand what you are asking.

Goto: Database > Links > Properties.

At the bottom of the page, click 'Add Column' . Enter the following details;

Type: TEXT
Name: ImageURL
Field Type: text-box

Then, in your templates (i.e link.html), have something like;

Code:
<%if ImageURL%> 
 <img src"<%ImageURL%>"> 
<%endif%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 23, 2003, 6:15 AM

dbode

Novice (9 posts)

Dec 23, 2003, 6:15 AM

Post #3 of 4

Shortcut

Re: [Andy] Edding Pictures and quering Database... In reply to

Hehe, great, that was really easy, thanks a lot.

Perhaps you can tell me if its possible to show the latest 10 Links out of just one category somehow on a non-linkssql page ? I want to show to our readers the latest Links on every page on our site.

Best regards,

Dennis

Dec 23, 2003, 7:14 AM

Andy

Veteran / Moderator (18441 posts)

Dec 23, 2003, 7:14 AM

Post #4 of 4

Shortcut

Re: [dbode] Edding Pictures and quering Database... In reply to

No prob :)

Here we go about the 10 newest links;

http://www.gossamer-threads.com/...ing=newest+10+global

Cheers

Andy (mod)
andy@ultranerds.co.uk