Job report ...
Results for The local supermarket
Job: now open Sunday
| English | | No. 1 - to be reviewed | No. 2 - to be reviewed | No. 3 - ACCEPTED |
| German | | | No. 1 - to be reviewed | No. 2 - not yet known |
| French | | | | No. 1 - ACCEPTED |
Job: Aubergines are down
| English | | | | No. 1 - to be reviewed |
Results for The greengrocer
Job: Buy local
| English | | | | No translation available |
| German | | | | No translation available |
Results for Well House Manor
Job: Broadband hotel in Melksham, Wilts
| English | | | | No translation available |
| French | | | No. 1 - to be reviewed | No. 2 - to be reviewed |
Job: Business accommodation for Melksham
| English | >>>>> | No. 3 - to be reviewed | No. 4 - to be reviewed | No. 5 - ACCEPTED |
| Dutch | | | | No. 1 - ACCEPTED |
| German | | | | No. 1 - ACCEPTED |
This output is from a sample program written by
Graham Ellis of
Well House Consultants to
demonstrate how a number of tables can be used to hold data
in the form of a normalised database, and that data can be
presented in a restructured report on a web page using PHP.
Related resources:
Source code of this example
Source code of simpler (bare bones) example
SQL to set up tables
SQL to set up sample data
"Designing a database" index
The page your on is the result of just a couple of
hours of work during a
public MySQL
course ... if you're new to online applications and have
a requirement to write a system such as this, you'll need to
learn both MySQL, and also
PHP.