[thelist] Help about DB search
Rui Madeira
ruimbmadeira at yahoo.com.br
Fri Jan 7 10:55:30 CST 2005
Here it goes a sample of the DB
I´m sorry but the info is in Portuguese (I´m from Portugal, Lisbon) but I´ve turn the fields name to English
Keith Gaughan <keith at digital-crew.com> wrote:
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
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
---------------------------------
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador do Yahoo! agora.
More information about the thelist
mailing list