Hello Well Bruce you spurred me into action, and I have produced some web pages, that allow users to search the database.
It can be a little slow, especially the passage height query. Even the form is slow to load, and no indication is given that it is working. Finding the heights are quite quick it is the checking to see if they are underground that take the time, oh well probably can be optimised, but someone better than me. It is set up so that more searches can be easily added. Known problems Passage height gives meaningless results if one or both of the heights given are between the min and max. AJAX menu does not work on all browsers. Which brings me back to the where this all started, it would be more user-friendly to do searches on passage names as people call them. IE how long is 'Route 66' Currently to do this they would have to know that 'Route 66' was made up of the second half of Diesel Duck plus Onion and the first half of 'hall of time'. The first and last of these is not searchable? Have a look at http://wotcc.org.uk/Cheddar/ (the style is stolen from ubss.org.uk) If people think that it is useful, I'll add the code to the wiki, you should be able to edit the config file and it should then drop in to any site. Extra Searches can be added to the Searches Directory, so it should be adaptable. Works with mySQL. Andrew
