how to display only 4 rows?

[Anon]

Hi I am trying to evoke just 4 most recent rows from the mysql DB.

I've tried Count but must be doing it wrongly.

If anyone knows how to do this Select SQL statement pls. help.

The code to be built upon is:
"select * from parts order by pid desc"

Alternatively maybe you can help with using select * and displaying only the first four rows using PHP.

I've tried while loop, which loops the whole lot, and for loop, which loops the same rows 4 times.

Any input much appreciated...

Greetz
Be_ix

[Anon]

$sql=select * from parts order by pid desc limit 4;

ron

[Anon]

Thanx Ron 🙂