need help-want to provide my local headlines to other local sites with links back

They have: 14 posts

Joined: Nov 2000

I run a local web site and have had requests to put my news headlines on other local sites. They will need to be updated remotely by me, and when clicked will display the information. Probably just by linking to my page rather than inserting in to their pages would be ok. Does anyone know how I can do this.
Thanks.
sgray.

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

are you any good with Databases Administration?

you could set up a 'public' user, and give that username/password out to those sites
the 'public' user would only have SELECT priveledges restricted to the table(s) that are used for news.
this has many advantages:
they can search past news articles
they can query for the last X articles
they can display headlines, and link to articles
they can customize the news on their own website

while I called this a 'public' user, you would only want the webmasters of those other sites to know the username/password.
if too many people know, others may try getting your news, and you'll loose some bandwidth

That's just how I'd do it. Because I've written news scripts for ASP with SQL 7 and PHP with mySQL, and it works great!

Mark Hensler
If there is no answer on Google, then there is no question.

They have: 61 posts

Joined: Aug 2000

i just helped out another guy using a script... and i think it would also work for you!!!

http://webmaster-forums.com/showthread.php?threadid=13166

The sites that want your news could just include this file... and it could just be a simple hyperlink, or ALL of the news! Makes your job very easy... just a cgi... and they can run it off of YOUR server!

For example... they don't have to bother messing with a install of the CGI... just install it on your server. Then all of the sites that want your news just add this whereever they want your news to be:

<script src="http://yourdomian.com/cgi-bin/include.cgi?currentnews.html"></script>
'

The link to what I just posted may or may not help... not very fancy.. but it WOULD do the job simple as pie.. and clean... all you have to update is a certain .txt or HTML file on your server... and they would NEVER have to change their website. If you have any other questions or problems i'm game to help you with another point of view...

God Bless

[Edited by exbabylon on Jan. 06, 2001 at 12:50 AM]

[=1]Blamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.[/=1]

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

good idea!
I've used stuff like that before, for (random) pictures on forums and stuff. I just never thought to use it for something like this.. DUH!

Mark Hensler
If there is no answer on Google, then there is no question.

They have: 14 posts

Joined: Nov 2000

Thanks for the suggestions, I have made up a little java script that gets the headlines from a small .js file and it works great.All I have to do is update the .js file and the headlines are automatically updated. But how do you display a java script(code) on a page for cut and paste but keep it from functioning.
Thanks,
sgray.

They have: 61 posts

Joined: Aug 2000

probably the best is to copy it into an HTML editor... it will brake it down into the proper charachters the fastest. If you don't have one you can just post it here as a code... then copy the HTML it produces.

[=1]Blamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.[/=1]

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

if you have an editor that has the 'replace' function..

find '>' replace with '>'
find '<' replace with '<'

that should be all you need

Mark Hensler
If there is no answer on Google, then there is no question.

mjames's picture

They have: 2,064 posts

Joined: Dec 1999

If you don't want to get too advanced, you could use what I use: a JavaScript that I use to display both a ticker script and a headlines box sort of thing. To see what I'm talking about, go to: http://www.sports-central.org/other/extras/headlines

Unforuntately, we have to update the headlines manually, but it updates automatically on remote sites. You can get a script off DynamicDrive.com.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.