Adding user commments to database records

2005-01-19 Thread Kentucky Families
I would like for logged-in site visitors to be able to submit comments to be appended to my database records. I've seen some databases that use a post-it-note style system. What might be the best way to go about this. The following conditions apply: Multiple users may post comments on the same

Re: Retrieving partial field values

2005-01-06 Thread Kentucky Families
A full-text search won't work. Too many records -- at least 8 million. From what I've read, full-text won't pick up the individual initials or very short names, like Vu, Lee, Doe, etc. Jigal van Hemert <[EMAIL PROTECTED]> wrote:> Example a (GivenNames): Mary Elizabeth or Marg Elizabeth > Exampl

Re: Retrieving partial field values

2005-01-05 Thread Kentucky Families
fields for 'surname alternate spelling 1', 'surname alternate spelling 2', etc. Is this the only way I can get the results I need? Thanks! Ian Grant <[EMAIL PROTECTED]> wrote: On Wed, 05 Jan 2005 12:22:18 +0000 Stephen Moretti wrote: > Kentucky Families wrote: > >

Retrieving partial field values

2005-01-05 Thread Kentucky Families
Very new to MySQL and this list. Thanks in advance for your patience with elementary questions. I'm in process of converting a current web site to a mysql database. As this database will eventually contain millions of records, I want to set it up properly. The database will contain transcripti