Hello, I previously figured out how to modify the "index/home" page of my site (www.RobertBrantley.com <http://www.robertbrantley.com/> ) so that it is unique. After that I figured out how to drop a box in called "Recent Stories" which take the headline of the last 15 stories and lists them in order with links. (I believe this may have been something Corey wrote. See below for the code. Sorry I can't find the link to this code at http://scoop.kuro5hin.org/sbe/) ----------- Here is the question: How do I perform a similar function except list stories written by a particular user as headlines? I want to set up a different column that only feature stories that I have personally written (under username Rob) to separate the type of content on the site and highlight my writings versus the general "rebroadcast" of news that is prevalent on the site. Another question: How do I perform a similar function except pull the headlines from another Scoop site that sits on the same servers? (IE: I would like to string the headlines from www.GreeneCountyDemocrats.org <http://www.greenecountydemocrats.org/> and www.137th.com <http://www.137th.com/> to my site as well.) --------- I have tried to play with it but have just about given up... are there any easy fixes for this as I am not techno-literate... only a bumbling user... ;) Rob -------- Here is the code I am currently using to get headlines from all published stories to show on the "index" page: # tweak the $story_count if you want to return more/less stories my $story_count=15; my ($rv,$sth) = $S->db_select({ FROM => 'stories', WHAT => 'sid, title', WHERE => "section<>'diary'", ORDER_BY => 'time desc', LIMIT => "$story_count" }); my $return; while (my $story = $sth->fetchrow_hashref()) { my $sid = $story->{sid}; my $title = $story->{title}; $return .= qq{|dot| <A HREF="|rootdir|story/$sid">$title</A> <BR>}; } $sth->finish(); return $return; www.RobertBrantley.com ---------------------------- I'm doing the best I ever did. I'm doing the best that I can. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.kuro5hin.org/pipermail/scoop-help/attachments/20060818/39ecc576/attachment.html