This topic is locked

Problem with Interval and table

4/18/2017 10:02:06 AM
PHPRunner General questions
H
htmalbenur author

Hi I want to put in the table the intervals of an age group, but I can not manage to put it in the tabelau, and another problem made it the table it appears on several small table how to do that will have a Single and only table showing the result
thx a lot.
sql code:
SELECT

fn_nord.Sexe AS Sexe,

fn_nord.Age,

COUNT(fn_nord1.Age) AS Quantité

FROM fn_nord

INNER JOIN fn_nord AS fn_nord1 ON fn_nord.Dossier = fn_nord1.Dossier

WHERE (fn_nord.Sexe ='Masculin')

GROUP BY fn_nord.Sexe, fn_nord.Age
http://imgur.com/dYPWIm5

http://imgur.com/5P4tsGG