MySQL... fetching stuff...

[Anon]

Okay, so I have an html form, and a php script that inputs the data from the form into a MySQL database, but...

Problem one is, when I display the data new 'posts' are displayed at the bottom instead of the top of the page.

Problem two, and the most anoying problem is this: When I retrieve the data from the database, all of it comes out... how can I get a specific 'post'to be displayed. What method should I use to do this?

-Thanx

[ducaonline]

Problem one is easy to solve, I imagine you store your data in a table, I would suggest that you use an attribute (let's say ID) with the "auto_increment" property, so that every new entry increments that attribute. In this way, when you try to fetch your results you just need to put an "ORDER BY" in your query, in this case "ORDER BY ID DESC", which means it will get first the last posts just as you need.

Problem 2 isn't really clear, but I guess solution for problem one works for problem 2 as well since you can address a result by it's ID and fetch it out with a WHERE clause

Hope this helps