3 small problems
Hello,
I am developing a site for my internship and I need a little help.
I am only 2-3 small problems and the solution may be obvious, but I do not find it.
My first problem is in the use of "dBReport".
I create a link by concatenation and it works. The link is successfully created.
My problem: I want display an image with this link, but we don't see it :/
Here is the code to show you:
{DBREPORT(db=>stageAP)} SQL "SELECT nom, site, CONCAT('\"http://www.lanup.be/images/partenaires/big/',image,'\"') AS logo, description FROM partenaires" GROUP [nom] "[nom]":h1 TABLE HEADER :even{cursor:pointer;} :odd{cursor:pointer;} CELL :{text-align:left;background-color:white;color:black;} "Site officiel" :i HEADER CELL :{text-align:left;background-color:white;color:black;} "{IMG(src="[logo]")}{IMG}" HEADER CELL :{text-align:left;background-color:white;color:black;} "Description : " "[description]" {DBREPORT}
The question, can we display images with "dBReport? You can see the page here
Second problem is an SQL query (I start in SQL queries 😛). I must make a "COUNT" on a field. I must say by event, how many people are registered.
I have 2 tables, "JoueursInscrit" and "Evenements". In "JoueurInscrit" I have a foreign key that points to "Evenements".
Currently, here's my query:
SQL "SELECT DISTINCT joueurInscrit.nomJoueur, joueurInscrit.evenements_id, evenements.id, evenements.nom, evenements.nbrJoueurMax, evenements.lieu FROM joueurInscrit, evenements WHERE joueurInscrit.evenements_id=evenements.id" GROUP [evenements_id] "[nom]":h1
The display of these informations is correct, it only remains for me the "COUNT " where I stuck.
If someone is good in SQL, can he help me with this? ^^
You can see my result here
.
Latest problem, I would like that the homepage is the page of items.
I go to general administration, I choose as my home page "Articles".
I save my preferences. But the homepage still is a Wiki page ...
Is this a known bug or did I make a mistake somewhere?
Thank you in advance for those who read this message and try to help me:)
Have a nice day