I have a website with simple signup sytem using php web pages and mysql database.
I add a line in current signup php page to include reffer member like:
referred by: ?
Now i want this:
When visitor enter a name in "referred by" field then system checks whether that name is present in db or not. If name is present then add 1 value in profile of that user who referred this visitor.
User profile should look like this:
No. of referrals: 1 (number of member joined bring by you)
Should i need to create a new field for this, like "referrer" in users table? if yes then how?