Hi everybody,

First, please excuse the lousy English, but my native language is German.
I am using a ready PHP solution for my genealogical research: The Next Generation of Genealogy Site Building ("TNG") - http://lythgoes.net/genealogy/software.php
This offers the possibility for reports using SQL SELECT functions to generate. Unfortunately, I really do not know how this works.

Here's an example how the result looks like (marriages per calendar month):
http://www.ahnendaten.de/ahnen/showrepo ... eportID=44

This used the following SQL SELECT function:
SELECT MONTHNAME(marrdatetr) AS month_in_which_married, MONTH(marrdatetr) AS month_of_marriage, COUNT(*) AS Totals, RPAD('',COUNT(*)/10,'=') AS Graphic FROM tng_families WHERE MONTH(marrdatetr)>0 GROUP BY month_of_marriage;

Unfortunately I am a bloody rookie with PHP and pchart, so I need all the help I can get.
Perhaps among the talented and brilliant programmers here there is one who is willing to tell me how to transform the SQL SELECT function so that these result will be displayed as a chart.
I am sure that many of the thousands of worldwide TNG users would be extremely pleased about a solution.

I would be happy for any helping answer and remain with best regards,
Thank you very much in advance for your efforts.
And greetings from Switzerland.

Ingo Gebhard
Frauenfeld, Switzerland

I have tried to solve it myself:



Unfortunately I get this error message:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/web673/html/tng/pChart/xx.php on line 16
- line 16 is while($row = mysql_fetch_array($Result))

Fatal error: Call to a member function addPoints() on a non-object in /var/www/web673/html/tng/pChart/xx.php on line 24
- line 24 is $myData->addPoints($Kalendermonat,"Kalendermonat");

Could anyone help me please?