MySQL show only the last 8 rows

Question

On my index page I have the "latest work" which shows 8 portfolio pieces and I need it to only grab the ones that have active = 1 as well and I have something like this:

$sql = 'SELECT * FROM portfolio WHERE active = 1';

I tried doing this but its not working and i get errors when I try to pass it in PHPMyAdmin as well.

$sql = 'SELECT * FROM portfolio 
        WHERE active = 1 
        WHERE [id] > SELECT
        MAX([id]) - 8 FROM portfolio';

Any ideas?

questions like these have been already answers a million of times... — dynamic, Sep 17 '13 at 20:02

score 2 · Answer 1 · answered Sep 17 '13 at 19:57

2

If you want to get the most recent 8 active pieces, use LIMIT as well as ORDER BY

$sql = 'SELECT * FROM portfolio WHERE active=1 ORDER BY id DESC LIMIT 8'

answered Sep 17 '13 at 19:57

aynber

22,380
8
50
63

score 1 · Answer 2 · answered Sep 17 '13 at 19:58

1

SELECT * FROM portfolio WHERE active=1 ORDER BY id DESC LIMIT 8

answered Sep 17 '13 at 19:58

Arun Kumar M

848
9
14

score 0 · Accepted Answer · answered Sep 17 '13 at 20:00

0

$sql = 'SELECT * FROM `portfolio` WHERE `active` = 1 ORDER BY `id` DESC LIMIT 8';

ORDER BY id DESC -> orders rows by highest to lowest value of ID, use ASC for opposite.

LIMIT 8 -> only 8 first rows

answered Sep 17 '13 at 20:00

Lkopo

4,798
8
35
60

MySQL show only the last 8 rows

3 Answers3