Urgent: Final Result As One Variable [PLEASE READ]

bradleydh

mysql_connect("localhost","username","password");
mysql_select_db("dbname");
$sql = "SELECT * FROM nuke_stories ORDER BY pn_sid DESC LIMIT 3";
$result = mysql_query($sql);

While ($row = mysql_fetch_array($result)) {
$title = $row['pn_title'];
$body = $row['pn_hometext'];
$posted_by = $row['pn_informant'];

$news = '<b>' .$title. '</b><br>
Posted By: ' .$posted_by. '<br>
' .$body. '<br><br>';
}
mysql_close();

This is part of a script that I am writing which extracts the 3 most recent news stories from my PostNuke database.

Now, I want to be able to call the final result (all three news stories) as one single variable. Any ideas on how to do this?

I am really stuck here... I don't know what to do next.

darkshady

$news .= '<b>' .$title. '</b><br>
Posted By: ' .$posted_by. '<br>
' .$body. '<br><br>';

The period before the = will make it so the content goes after all the current content of the variable.

Blob

Can't you just stick them togethor with "."?

bradleydh

calling the $news variable, you are only getting the first variable of the three... I want all three under one variable.. Is this possible?

laserlight

darkshady has given your solution.
try it
if you need to, set
$news = '';
before running the loop.

bradleydh

Originally posted by darkshady
$news .= '' .$title. ' 
Posted By: ' .$posted_by. ' 
' .$body. ' ';
The period before the = will make it so the content goes after all the current content of the variable. [/B]

The period before the = repeats the first article... I want it to go onto the second article.

Blob

???
Didn't we just answer that? 😛

You can stick the three values togethor with ".".

$allthree = $one . $two . $three;

Blob

Ahh! Everyone keeps posting while I'm typing! 😛
First darkshady, then you two! :mad:

bradleydh

...Here is what happens... When I put them all together, I get 3 copies of the first article... Any other ideas?

laserlight

mysql_connect("localhost","username","password");
mysql_select_db("dbname");
$sql = "SELECT * FROM nuke_stories ORDER BY pn_sid DESC LIMIT 3";
$result = mysql_query($sql);

$news = '';
while ($row = mysql_fetch_array($result)) {
	$news .= '<b>' . $row['pn_title'] . '</b><br>
Posted By: ' . $row['pn_informant'] . '<br>
' . $row['pn_hometext'] . '<br><br>';
}
mysql_close();
echo $news;

could you try that and see?

bradleydh

Thank you everyone!

This works perfectly!