[thelist] Re: Help about DB search

Keith Gaughan keith at digital-crew.com
Fri Jan 7 09:27:04 CST 2005


Rui Madeira wrote:

>>I need a easy script that can help me in a search with a Access data
>>base, that will be presented in a web site.
> 
> The data base as only one table, with 6 fields of informations:
> cities, URL (it can be more than one),  4 digit code, specific
 > information in URL, classes of information (agruped in 4 classes),
> type of  information (agruped in three types).

Any chance of some sample data? Your description of what the URL field 
contains is a little vague: are the URLs stored together in the one 
field in the one row or is the data identifying the the URLs
(cities--why plural?--type, and class)

> The search in the DB will be made only by three fields: cities, class
> and type of information. All of them will need to have a "combo box"
> for the user choose what he/she wants to search. The result of the
> search would be a table with the name of the city specific information
> in URL and the URL to make the link.

I think a link to a copy of the database, either empty or with some
sample data, would be useful. Also, I think your schema may be in need
of some normalisation. In particular, the cities should problably be
moved to their own table so that you have one canonical list of them.
They can then be referenced in your main table.

K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://digital-crew.com/


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 06/01/2005



More information about the thelist mailing list