Behind the scenes Leatherlips and I have been observing a few little areas of the forum that need tweaking for 100% accuracy. If you have incorporated the searchlog.asp mod and have it working, did you notice the General Statistics statement "55 searches have been performed since 08 June 2008 at 06:21:37." The date that has been extracted from the database, is in fact the last date of a recorded search and not the first date. The page code has a dim FirstSearchDate which currently pulls the last date. To rectify the problem:
Searchlog.asp line 75
find:
strsql = "SELECT SLS_DATE FROM " & strTablePrefix & "SEARCHLOG_SEARCHES ORDER BY SLS_DATE DESC"
replace with:
strsql = "SELECT SLS_DATE FROM " & strTablePrefix & "SEARCHLOG_SEARCHES ORDER BY SLS_ID ASC"
Now the statement will pull the first stored search date.
Happy editting.. Oops 'editing', thats better! Andy

<

Thanks for that, any more good spots ?<

If you read Leatherlips and my posts, generally that is what they are about, finding the spots
example with Post History here<