show_news.php?id=

[Anon]

Hi everyone!

I have a bit of a problem.

I wanted to make a news publishing script that made it possible to enter a title, a little description and a content part in a HTML form.
No problem, yet.

Then I wanted the news to be shown on my index-page. But not the entire news!
I wanted to have the title and description-part shown. And at the bottom of the news there was a link like "Read more..."
The link would now be connected to show_news.php?id="the id MySQL has given the news"
Still no problem!

On the next page I wanted to have the whole
news shown with title, description and the content!

How can I make this happen??

I appologize my English and my bad description of this problem, but I hope som of you may get the point and give me a good hint!!

Thank you so much!

Greetings from a Norwegian Newbee!

[jburfield]

So, which part does NOT work? The page that shows the entire news story?

If you are passing in: id=XX, then you need to perform a query to the database pulling out the data for the record that has id XX.

Just pulling the data for your list page and then passing that through to the 'full' story page will not work without either A: pulling the record for that ID, or B: passing the entire text of that particular story through in the URL, which is a bad idea.

Do you have a query on the news page to pull out the info?

-- Jason

[Anon]

Exactly, the page with entire news story is the one I've got trouble with.

This is the script that shows us the page without the content. The link will now connect us to eg. show-news.php?id=4

<?php
$connection = mysql_connect("localhost" , "user" , "password");
$db = mysql_select_db("news" , $connection);
$query = "SELECT * FROM news ORDER BY id DESC LIMIT 5";
$result = mysql_query($query);
echo ("<table border = '0' width = '100%'>");
while ($rows = mysql_fetch_row($result))
{
// $rows[4] = ID (generated by MySQL...)
// $rows[1] = Title
// $rows[2] = Description
// $rows[3] = Author
echo ("<tr><td>$rows[1]</td><td>By : $rows[4] </td></tr>");
echo ("<tr><td colspan='2'>");
echo (nl2br($rows[2]));
echo ("</td></tr>");
echo ("<tr><td><a href='show_news.php?id=$rows[0]'>read more...</a></td></tr>");
}
echo "</table>";
?>

So my problem is simply, how should show_news.php look like to work properly?

Thanx again!

[Anon]

I made a mistake in the other message.
This is what the rows gives us;

// $rows[0] = ID (generated by MySQL...)
// $rows[1] = Title
// $rows[2] = Description
// $rows[4] = Author

Sorry!

[wchris]

I am sorry, but I do not really understand your probs :-(

1.)
<em>$connection = mysql_connect("localhost" , "user" , "password");
$db = mysql_select_db("news" , $connection);
$query = "SELECT * FROM news ORDER BY id DESC LIMIT 5";
$result = mysql_query($query);</em>

I am not such a pro, but shouldn´t this better look like this:

<em>$result = mysql ("news", "SELECT * FROM news ORDER BY id DESC LIMIT 5");
$num_rows = mysql_num_rows ($result);

for ($row = 0; $row < $num_rows; $row ++) {
....
}</em>

2.)
show_news.php:

<em>$result = mysql ("news", "SELECT * FROM news WHERE id = '$id'");</em>

You will now find your news in the row number 0.

<b>In my opinion you should make some exception handling. For example:
if ($connection) {
go one with script
}
else {
make error message and die
}
</b>

[wchris]

Sorry this em-TAGS should not be shown - ignore them :-)