selecting the right news from mySql database

[oaskedal]

Hi!

I'm all new into sql and php and need some advice for my newsdatabase. How do I fetch the second newest publicated news with sql and php that has been placed in my database. It should appear in my index.php site. What would the code be to make it happen? I have, somehow, made the latest news display in my index.php...

I've been trying to find a good starting example in php-code, but as I'm 😕 in what it all means, I'd better not.

Anyone to explain and show me ?? 🙂

Thanks!

[Piranha]

First you have to understand that relational databases does not have any kind of order in what it stores or retrieves. That is your responsibility to handle.

If you have a field that you can use to order things you add ORDER BY abc to get the right order. Then you can use LIMIT to select what posts you are after, LIMIT 1,1 would take out the second result.