Display text on my site / news

Anon

Hello there
Im new to this php /Mysql.
What I would like to do is display new /latest update on my page.
It wil go like this on my page

bla bla blabla bla blabla bla blabla bla blabla bla blabla bla blabla bla blabla bla blabla bla blabla bla bla
then link to more on the subject.
more on bla bla

Im thinking og using Mysql to store the data.
Make form with two windows to write in.
One to write the text to display on page an other to display the page that is linked to the text.
If I knew a way to do this so that the data is connected in some way so when somone come to the page he see update-text and can mouse on more for ull info on update

If some one can help me whit this i would be great.

thank's

jburfield

I'm not exactly sure what you are trying to do here, but I think it's something like the following:

Let's say you have news stories with headlines. They could be linked like this:

NEWS STORY HEADLINE
blah, blah, blah, blah..........< more >

At least this is how I do it.

Create a table in MySQL for the following info:
id
date_posted
headline
story

(add more if you need them)

To display the newest items on a 'summary' type page, just do something like this:

select id, headline, substring(story, 1, 100) from TABLE order by date_posted

This will give you the id of the story so you can link to it, the headline of the story, and the first 100 characters of the story itself.

From there, you can do something such as this with the result set:

while($row = mysql_fetch_row($query_result))
{
$id = $row[0];
$headline = $row[1];
$story = $row[2];

print("<a href=\"newspage.php?id=$id\">$headline</a><BR>");
print("$story");
print("<a href=\"newspage.php?id=$id\"> Full Story</a>");

Is this sort of what you are looking for?

-- Jason

amcgrath

To get the first sentence, instead of the first 100 characters, try:

$summary = substr($full_text,strpos($full_text,"."));

jburfield

It's just me, but I probably wouldn't do this. If you have a story about "Dr. Smith", you will end up with "Dr." and nothing more.

Just a thought.

-- Jason

Allen McGrath wrote:

To get the first sentence, instead of the first 100 characters, try:

$summary = substr($full_text,strpos($full_text,"."));

amcgrath

Good point.

Anon

This is exactly what Im looking for
Thank you all for good response
Thank´s