I've got a php news script on my site, it works well, except for the fact that the new news is entered at the bottom of the page and the old news stays at the top.
So, unless I edit the news data to turn the tables around everytime I enter some news it will stay the same.
Is there a script I can enter to flip the tables around or so that next time I enter some news in it enters it into the top instead of the bottom? thanks.

news script: http://membres.lycos.fr/enterthefog/update/news.php

Turbonutter wrote:
> $fp = fopen( "news.txt", 'a' );
>
> Change to the "a" to "r+", see about that.

Tried that. Didn't work, it overwrites instead.

$fp = fopen( "news.txt", 'a' );

Change to the "a" to "r+", see about that.

OK, I've got it for you... Sorry bout posting all this code, i just thought it'd be easier. basically it just reads the content of the file as it is at the moment, then adds that onto the end.

--------------------------

print "

Submit News

";
if ( isset($actionflag) && $actionflag == "join")
{
if ( ! file_exists("news.txt") )
{
touch("news.txt");
}

$fopen_contents = fopen ("news.txt", "r");
$fread_contents = fread ($fopen_contents, filesize ("news.txt"));
fclose ($fopen_contents);

$fp = fopen( "news.txt", 'w' );
fwrite ( $fp, "

"); fwrite ( $fp, "$form[subject] " ); fwrite ( $fp, "Posted by $form[author] " ); fwrite ( $fp, "$form[text]" ); fwrite ( $fp, "

\n");
fwrite ( $fp, $fread_contents);
print "News Sent!";
}
if ( isset($clearflag) && $clearflag == "clear")
{
unlink("News.txt");
touch("News.txt");
print "Database reset!";
}
?>

It's not Mysql

ok, ok i'll post the script:

print "

Submit News

";
if ( isset($actionflag) && $actionflag == "join")
{
if ( ! file_exists("news.txt") )
touch("news.txt");
$fp = fopen( "news.txt", 'a' );
fwrite ( $fp, "

"); fwrite ( $fp, "$form[subject] " ); fwrite ( $fp, "Posted by $form[author] " ); fwrite ( $fp, "$form[text]" ); fwrite ( $fp, "

\n");
print "News Sent!";
}
if ( isset($clearflag) && $clearflag == "clear")
{
unlink("pages/news.txt");
touch("pages/news.txt");
print "Database reset!";
}
?>

Right, what you need to do is sort through all the code and find the EXACT MySQL query that fetches the data from the table to display on the page. This shouldn't be hard. You need to tack this on to the end of the query:

ORDER by DESC

(or ASC, I can't be bothered to work it out)

This is assuming you know something about MySQL :) If not, just paste the query here and I'll modify it for you.

I don't want to spam the thread up with the full code, could you download: http://membres.lycos.fr/enterthefog/update/news.zip

the file is called npost.php it's one of two files :)

Have you got the PHP Code bit, which adds the Text to the file???

the actual script is very small, it's mostly all tables, it stores the info for the page you see when your updating:
Title Date
text..........

and for what you see on the news page where it's all updated to.

Date:


Subject:


News:

thats the whole thing, including the updating page.

Is it a big Script????

I know next to nothig about php, I was just hoping there was something I could change in the script to make the old news move down :)

atm it write all the news to a text file, it's all stored in there.