Hello
I'm using "PHPRunner" to build a Database for persons.
the structure of the database is
in this picture
I have the following code:
PHP Code:
SELECT
test.Nom,
test.Prenom,
test.`N°`,
test.Idtitle,
test.Idposition,
test.IdInstitution,
test.IdDepartment,
test.Adresse,
test.ZIP,
test.Idcity,
test.Idcountry,
test.Phone_number,
test.GSM,
test.Fax,
test.Email,
titre.Title,
`position`.Position_en,
pays.Country,
institution.Institution,
departement.Departement,
city.City,
GROUP_CONCAT(language.Langue ORDER BY language.Langue SEPARATOR ';') AS languesParlees
FROM test
INNER JOIN titre ON test.Idtitle = titre.`N°`
INNER JOIN city ON test.Idcity = city.Idcity
INNER JOIN departement ON test.IdDepartment = departement.IdDepartment
INNER JOIN institution ON test.IdInstitution = institution.Idinstit AND departement.Idinstit = institution.Idinstit
INNER JOIN `position` ON test.Idposition = `position`.Idposotion
INNER JOIN pays ON test.Idcountry = pays.Idpays AND institution.idpays = pays.Idpays AND city.Idpays = pays.Idpays
INNER JOIN rel_lang_pers ON test.`N°` = rel_lang_pers.IdPersons
INNER JOIN `language` ON rel_lang_pers.Idlanguage = `language`.`N°`
GROUP BY test.Nom, test.Prenom
ORDER BY test.Nom, test.Prenom;
i manually added the lines:
PHP Code:
GROUP_CONCAT(language.Langue ORDER BY language.Langue SEPARATOR ';') AS languesParlees
and
PHP Code:
GROUP BY test.Nom, test.Prenom
ORDER BY test.Nom, test.Prenom;
Unfortuantely, when trying to view my database on firefox, i have the following error code:
Quote:
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; AS `test.Prenom;` FROM test INNER JOIN titre ON test.Idtitle = titre.`N°` I' at line 1
|
the file containing the error is said to be:
the error line is number 40
Could any one help me.
creating a database of persons on php-mysql
