Reversing order when writing to a file... I geuss...

[bR14n]

Hey! I got a question. I made a little tagger script to add a little interaction with my website. But when the posts come in, the older ones stay on top, and the newer ones go on the bottom. How do I reverse this? Oh, and also if a poster submits any word with apostrophes and stuff like that, there is always a "\" before it. How do I fix that too?

-Brian

[bastien]

the "\" is a safety feature that ensures that certain codes are escaped to prevent problems - php has the magic_quotes function set up in the distribution

to show the messges without the "\" use [man]stripslahes[/man]

for the order problem, change the sql statement to sort ASC as the default, if not included is DESC

select * from table order by date ASC

hth

[daveyboy]

i understand you're not using a db to store your data - otherwise you'd need the slashes.

if you're storing the data in a file, when you add a new entry to your file, you should fopen() the file, then rewind($fp) to move the pointer to the start of the file, then write the new entry to the top of the file.

[barand]

for the order problem, change the sql statement to sort ASC as the default, if not included is DESC

select * from table order by date ASC

For ASC, read DESC and vice versa