Re: [Phpgedview-talk] need help with table structure
Brought to you by:
canajun2eh,
yalnifj
From: Kyle M. <mat...@gm...> - 2007-05-08 13:28:01
|
Sorry, I must not of been clear enough. I need help understanding the database schema for phpgedview, how to retrieve the place names for different dates. E.g. if John Smith was born April 1, 1823, how can I retrieve off the database where he was born? Could someone please just tell me where in the existing phpgedview code this is done so I can duplicate that? Thanks, Kyle On 5/8/07, peter <pet...@hc...> wrote: > > Kyle, > > DB2 is a IBM product, you can find information, > http://www-306.ibm.com/software/sw-bycategory/subcategory/SWB30.html > > The opensource information from IBM, > http://www-128.ibm.com/developerworks/ibm/osource/ > > May be this pages can help you. > > Regards, Peter Al > > > Kyle Mathews schreef: > > My family is attempting to organize our genealogical information on the > > internet. We are using three sites. We're using PhpGedView > > <http://www.familyhistory.mathews2000.com/gedview> to organize the > > normal genealogical information. Then a wiki to organize stories > > <http://www.familyhistory.mathews2000.com> / autobiographies and other > > such text. And then Gallery to organize photos > > <http://www.familyhistory.mathews2000.com/gallery> of our ancestors. > > > > We're pleased with the setup, especially PhpGedView, but are working on > > fixes to improve the sites. One thing I'm working on is with the wiki. > > Each ancestor has their own wiki page from which is linked all stories > > related to them. We want each ancestor page to have on it basic > > biographical information (birth, marriage, death, etc.). To ensure that > > the information is accurate we want to import the data to the wiki from > > PhpGedView. Right now we're just taking the person's PhpGedView page > > and placing it in an IFrame on the wiki. That works, but it's slow and > > has too much information. > > > > What I'm trying to do now is write a php script which will pull only the > > information we need off the PhpGedView database and place it in the > > wiki. I've got part of it working -- I can get the dates off the > > database but am confused how to get the places associated with those > > dates off the database. > > > > I've looked through the documentation but couldn't find anything > > useful. If it is there, someone please point it out to me. Else, just > > point me toward the code which performs this function in PhpGedView. > > This is my first PHP project but I can read PHP code alright. > > > > Thanks in advance, > > Kyle Mathews > > > > > > ------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by DB2 Express > > Download DB2 Express C - the FREE version of DB2 express and take > > control of your XML. No limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Phpgedview-talk mailing list > > Php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Phpgedview-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpgedview-talk > |