Retrieving from bottom to top

[Anon]

Good day everyone,

I'm using mysql_query and mysql_fetch_array
to retrieve all the info in the database
( its for a news posting ).

It retrieves and display fine its just that I need to put the last entery in the database first then the second last and so on ( like begin at the bottom and then go up )

Does anyone know how I could maybe find out how many rows in the database and save it to a variable?
or a way of doing this?

[Anon]

select * from table_name order by date desc

the opposite would be asc

[Anon]

yes, all you would do is add ORDER BY [field] [desc/asc] to the query for descending/ascending order respectfully.

read up on the MySQL documentation, there's a lot of helpful stuff in there that saves time and work.

[Anon]

K thanks alot guys that work perfectly.

The other prolbem I'm having now is saving it correctly.
When the user enters what ever into the textarea box it does get saved but if you hit enter for a new line it does not get saved
like this textarea here for entering:

those empty new lines I put in do not get saved to the database.

any suggestions on that?