Read from bottom to top

Anon

I've got at small forum-like site, where it's posible for everyone to add an message.

Now, my problem is, that i would like to read all the messages from bottom to top.
The reason for this, is that i'd like the newest message to be shown at the top.

To see what i meen, look at:
htt://www.tstalle.dk/besked

Hope somebody can help me.

/Torben

jc94062

ORDER BY somethingintable

Where somethingintable is a field which contains the details, for mine I used date, as yy.mm.dd.hh.mm.ss, that way the largest value always goes at the top and so its sorted by date and time. If it sorts in the wrong order add DESC to the top order query.

Hope that helps.

Anon

I'm sorry. Maybe I schould have told more about the site. When it writes a new message it opens the file, contaning the messages.

To make it easyer, this is the code for the page:
if ($message)
{
$name = strip_tags($name);
$mailaddy = strip_tags($mailaddy);
$message = strip_tags($message,"<a>,,,, ");
if (get_magic_quotes_gpc())
{
$message = stripslashes($message);
$name = stripslashes($name);
$mailaddy = stripslashes($mailaddy);
}
$message = ereg_replace("\r\n\r\n", "\n", $message);
$date = date("l, F j Y, h:i a");
$message = "$name -- $date $message <HR>\n";
$fp = fopen (basename($PHP_SELF) . ".comment", "a");
fwrite ($fp, $message );
fclose ($fp);
mail("stalle@tstalle.dk", "Besked på www.tstalle.dk", $message, "From: $mailaddy");
}

// the @ suppresses errors if the file is missing
@readfile(basename(($PHP_SELF . ".comment")));
?>

My problem is, where do i put in the ORDER BY, and will it in fact work in this case?

Just to finish off, i proberly should tell you, that this is the first PHP i've ever made.

Hope you can help me

/Torben

jc94062

From what I can see, (its pretty unclear with all the HTML tags that must have executed) your not reading from a db just a text file, in which case I'm not sure if you can order it I'm afraid, maybe someone else has some idea?

Anon

Ok.

Maybe you can tell me, how i can write to the top of an txt-file, instead of the bottom.
As it works now, a new message is added to the bottom af the file, but, if I could write a new message to the top of the file, my problem would be solved.

(Still) hope that you can help my.

/Torben

p.s
I don't have access to mySQL, that's the reason i've made it the way I have.

danleighton

Hi...

line 4 of this code snippet is a change we made to the view.php script of obbok from obsessed.org, it definitely achieves the reversing effect but don't ask me where it needs to be inserted in your script I don't know!

let me know if you figure it out....

if (file_exists($data))
{
$afile = file($data);
for ($num = count($afile)-1; $num >= 0; $num--)
{
$bfile = explode("|",$afile[$num]);

Anon

I appriciate the effort that you all put in the task of solving my problem.

But, I belive that i could solve my problem in another way.

The problem is, that the file, all the messages are written to, is more or less HTML.
So, a way of solving the problem, would be, to alternate my script, so that every new message is written to the top of the file, insted of the bottom. Hope you can help me.

To dan, I couldn't get the script to work. Belive that it's more based on a file, written in "list-format"

Think this is the last time I'll write in this topic

/Torben