Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: HTML page for every link

Quote Reply
Re: HTML page for every link In reply to
sorry.. i wanted to clarify something..

i beleive this is the best way to do it..

New Field in Links Database..

Name: isDetail
Size: 3
Max : 3
Default: No
Validation: Yes|No

Then in nph-build.cgi.. sub build_detailed_view

find:

Code:
$sth = $LINKDB->prepare ("SELECT * FROM Links LIMIT $set_limit");

change it to

Code:
$sth = $LINKDB->prepare ("SELECT * FROM Links WHERE isDetail = 'Yes' LIMIT $set_limit");

it works great now.. it should be faster and save more memory.. the last way you did it lcnl it gets all the links and then skips the one that isn't detailed.. this one only gets the detailed ones..


------------------
Jerry Su
Subject Author Views Date
Thread HTML page for every link lcnl 3116 Nov 19, 1999, 4:17 AM
Post Re: HTML page for every link
widgetz 3011 Nov 19, 1999, 12:53 PM
Post Re: HTML page for every link
pugdog 3005 Nov 19, 1999, 5:46 PM
Post Re: HTML page for every link
Alex 3022 Nov 20, 1999, 11:26 AM
Post Re: HTML page for every link
pugdog 3015 Dec 22, 1999, 12:12 AM
Post Re: HTML page for every link
lcnl 3042 Dec 22, 1999, 12:44 AM
Post Re: HTML page for every link
widgetz 3006 Dec 31, 1999, 6:38 AM