Hi, would it be hard to have search.cgi search two linksSQL databases at once and display their results. I would like to display the top 5 link matches (no cats) from the second database.

Thanks
Shane

It shouldn't be hard, but it depends on how you have your system set up just how easy it would be to do.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Say you have both sqls on one machine in one mysql; then you could change the text inside your build.cgi? to show the top five to something like:

prepare second instead first; get the choosen links from table ...
thats it.

Watch the sql statements clearly.

Robert

I am on my own server so I should be able to interact with the databases pretty easily. I'm quessing that I should modify search.cgi only. Am I right? I only need five links shown from the second database with no category shown. Will I have to just double the searching code but pointed towards the second db?


thanks for the replies
Shane