[korro]

I hope if there is somebody who wanne make a database script with search option.
I do not know a lot of PHP, I find somewhere on the web a script what almost work the same as I want. But I cannot get this script working. This is because the scripts I know are already in maps and folders. This script is with as text online.
The script where I am talking about is: http://www.essetee.be/les_php_en_mysql.php

This script is in Dutch but it is an addressfile script.
I wanne use this script for making a graveyard administration.
This script is good for using because they use a way of database where it is easy for my to copy our datas from excel to this one.



They use this format:

INSERT INTO `pem` (`pem_id`, `pem_naam`, `pem_voornaam`, `pem_straat`, `pem_nr`, `pem_gemeente`, `pem_zip`, `pem_tel`, `pem_gsm1`, `pem_gsm2`, `pem_email`)

The rest of this part you can find here: http://www.essetee.be/downloads/pem.sql

The things I wanne have in my database are: (13 fields)
grave_id, = translation in Dutch = grafid
grave_number, = translation in Dutch = grafnummer
grave_namefirst, = translation in Dutch = naameerstoverledene
grave_firstdateofborn, = translation in Dutch = eerstoverledenegeboren
grave_firstdateofdieing, = translation in Dutch = eerstoverledenegestorven
grave_namesecond, = translation in Dutch = naamtweede
grave_seconddateofborn, = translation in Dutch = tweedegeboren
grave_seconddateofdieing, = translation in Dutch = tweedegestorven
grave_namethird, = translation in Dutch = naamderde
grave_thirddateofborn, = translation in Dutch = derdegeboren
grave_thirddateofdieing, = translation in Dutch = derdeoverleden
grave_place, = translation in Dutch = vaknummer
grave_paidtill = translation in Dutch = grafrechten

With this script people could be searching online for this information.
Putting on new dates in this database is not necessary because I wanne copy it from excel to it.

I maka a little lay-out of how to look like

------------ begin start page ------------
how people can search
http://www.begravenintilburg.nl/test/zoeken.html

1 grafnummer (grave_number)
2 naam eerst overledene (grave_namefirst)
3 geboortedatum eerst overledene (grave_firstdateofborn)
4 overlijdingsdatum eerst overledene (grave_firstdateofdieing)
5 naam + geboortedatum eerst overledene (2+3)
6 naam + overlijdingsdatum eerst overledene (2+4)
----------- end start page ------------


------------ begin search page ------------
How to Search:
from fields 1 (grave_number) and 5 (2+3) I give you the lay out
field 1: http://www.begravenintilburg.nl/test...verledene.html
field 5: http://www.begravenintilburg.nl/test...neendatum.html

ZOEKEN NAAR GRAVEN BEGRAAFPLAATS WEST = SEARCHING FOR GRAVES
naam eerst overledene = name of first person who died
start zoeken = start seaching
----------- end search page ------------


------------ begin not found ------------
When nothing found this page: http://www.begravenintilburg.nl/test/444.html
terug naar zoeken = back to searching
----------- end not found ------------


------------ begin not found ------------
When nothing found this page: http://www.begravenintilburg.nl/test/444.html
terug naar zoeken = back to searching
----------- end not found ------------


----------- begin results --------------
http://www.begravenintilburg.nl/test/gevonden.html

When results are found it must be looking like this
grafnummer = (grave_number)
naam = (grave_namefirst)
geboortedatum = (grave_firstdateofborn)
overlijdingsdatum = (grave_firstdateofdieing)

terug naar zoekveld = back to searching

Now people can click on one of this field to get the whole information.
----------- end results --------------


----------- begin whole info --------------
The total results must be looking like this: http://www.begravenintilburg.nl/test...nformatie.html

grafnummer: grave_number
vaknummer: grave_place
naam eerst overledene: grave_namefirst
geboortedatum eerst overledene: grave_firstdateofborn
geboortedatum eerste overledene: grave_firstdateofdieing

naam tweede overledene: grave_namesecond
geboortedatum tweede overledene: grave_seconddateofborn
geboortedatum tweede overledene: grave_seconddateofdieing

naam derde overledene: grave_namethird,
geboortedatum derde overledene: grave_thirddateofborn
geboortedatum derde overledene: grave_thirddateofdieing

looptijd graf tot: grave_paidtill



grafinformatie = graveinformation
terug naar gevonden zoekresultaten = back to search results

----------- end whole info --------------


I hope there is somebody who wanne write this PHP script for me.
But thanks anyway.