Looking for simple PHP code that...?

scaryhunter

Hi all !
Okay i'm looking for a PHP code where i want to retrieve a data from SQL database "BASED" on the newest submitted news.

Suppose i have a News table where i add news from time to time, but i want a certain php website to retrieve (select) newest data to be displayed on the page.

News table would sure contain (NewsID,Text,Date)..
Suppose i wrote ----- $result = $conn->query ("Select Text from News where ????what????")
I hope that made sense, like when you visit a website that has a marquee display that shows Latest submitted news only.

Thank you so much for reading,
scaryhunter

Rodders

What you need to do is write your query so that it sorts the data into the order you want, and you could also limit the number of results to a certain portion of the entire table contents:

$result = $conn->query ("Select Text from News ORDER BY Date desc limit 0,20");

MySQL ORDER BY

MySQL LIMIT

An additional word of warning - I think using the column name "Date" could cause some issues. I'm pretty sure it's a reserved word. Choose something like "NewsDate" instead.