You are on the right track that you don't want to modify the database
just to add a "level". You also want to have your "levels" in one
column/field so that you can use an index to search it quickly and
easily.
You didn't mention whether someone can be referred on multiple levels,
this will r
- Original Message -
From: "Daren Cotter" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 2002 7:34 PM
Subject: Multiple Referral Levels
> I have a question regarding tracking multiple referral
> levels in a database. The number of referral
