[kenfused]

Hello
I'm trying to make a database with a single column with 20 rows.
(I think I can do this with PHPmyAdmin.

From there. I want to know how I (using PHP) can add a value to one of the 20 rows, after 20 items have been added, adding a new value pushes off the oldest one.

Then I want to be able to get the contents of the table as an array.

I'm trying to make a "Last 20 searches" for my website.
I have the search function done, Now I want to add this table of 20 values, that can get added to and updated with each search query.

Thanks!
K

[ChristGuy]

Greetingz...

An eaisier way would be to add a date field and sort on that:

PHP Code:

SELECT * FROM Searches ORDER BY Date ASC LIMIT 0, 20 

That will return the 20 dates in ASCending order...

[kenfused]

that seems like a good idea... That way, it would be easy to grab the top 20 most recent.

Is there a way to keep only the 20 most recent search terms, to purge the last ones? Or will the database keep on growing?