How do I pull the latest x amount of entries from a mysql table and then display it in an html table, using PHP?
I assume your table looks something like this:
CREATE TABLE reviews {
review_id INT NOT NULL AUTO_INCREMENT PRIMARY,
titleofreview TEXT,
yourreview TEXT,
[...]
created DATETIME
}
So when you retrieve the latest four reviews, it would probably use a query that looks like this:
SELECT titleofreview, yourreview
FROM reviews
ORDER BY review_id DESC
LIMIT 4
If you only use a date to order them, then replace review_id
with created
.
As for putting it in a table, here is a guide to making tables in HTML.