Last 10 Searches - Directory Script

[cray]

Hi all,

Can anyone push me in the right direction for how to create a "View Last 10 Searches" page like the one on wowdirectory in php?

Many Thanks

[hatchet]

First you'll need some type of flat file or database that stores the search strings. Then do a select like
SELECT search FROM searchstring ORDER DESC LIMIT 10

[hatchet]

oops.. your table searchstring should have 2 columns - id and search.. then do your select
SELECT * FROM searchstring ORDER BY id DESC LIMIT 10

[cray]

Thanks hatchet, sorry I am not good with this stuff, how would I store each search query everytime someone searches?

[hatchet]

You have the search functions already in place I assume.. at the end of that call another function to insert it into the searchstring table..
function addlastsearch($q) {
$q=trim(addslashes($q));
$sql="INSERT INTO searchstring (id, string) VALUES ('', '$q');
$result=mysql_query($sql) or DIE("Could not insert");
}

Something like that anyway.

[cray]

Thanks Hatchet, I will hack around with it and see what happens!