Help with Linking Query (Archieve News)

[Andrius]

ok what I have is this: [a href=\"http://www.nicaprojects.com/archieve.php\" target=\"_blank\"]http://www.nicaprojects.com/archieve.php[/a]

all that I have display on the page linked above is:

$date : $subject

however the full query returns all results from my news table and puts the results into variables which are:

$subject
$body
$date
$image
$news_id

Now because I don't want users scrolling through a TON of articles I want these shortened down versions to be clickable (link) to the full news article that can be seen on: [a href=\"http://www.nicaprojects.com\" target=\"_blank\"]http://www.nicaprojects.com[/a]

I have re-searched this to no-end but because I'm not sure how to work my question properly I come back with 0 results.

ANY help will be appreciated in this matter. Thanks in advance
-Dave