[Bonzo]

Hello all

I have finished a site and am now starting to worry what can go wrong : (

First thing I have thought of is that I am displaying all the items in the database and this page could get very large.

What I would like to do is display only the last 5 items input and anything else would have to be searched for.

Below is my current query; can someone help me out please.

Anthony

PHP Code:

// Quick note - apporve only displays items that have been vetted by the site admin.

$query = "SELECT text, title, id, DATE_FORMAT(date_l, '%d %M %Y') AS date FROM table WHERE approve ='Y'"; 

Page - http://www.b-secure.biz/lost/list.php

[Keith]

PHP Code:

$query = "SELECT text, title, id, DATE_FORMAT(date_l, '%d %M %Y') AS date FROM table WHERE approve ='Y' ORDER BY id DESC LIMIT 0,4"; 

[Bonzo]

Thanks for the help Keith; I will give it a go but cant tell if it works yet as I only have one entry in the database so far !

Anthony

[steveo]

Keith, what does the 0,4 stand for?

When I do mine, I do the same as you but put the full number there, eg 10.

Is there any difference?

[Keith]

Oops, that should be 0,5... stupid typo.

No difference really, it means you start at zero and count up to 5. It's used better if you're spanning hundreds or thousands of rows over many pages.