Confused by the Help re extra mysql fields

[bburgess]

Hi guys

Sorry this has me confused in the help it states:

If you have added custom profile fields to any (or all) of the login objects then you must also create these fields in the database.
Custom profile fields must be named extra1, extra2, extra3 etc!
The following SQL query generates a table with 5 extra custom profile fields:

Code: Select all

CREATE TABLE `USERS` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`fullname` varchar(75) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(75) NOT NULL,
`active` tinyint(1) NOT NULL,
`code` varchar(75),
`extra1` varchar(100),
`extra2` varchar(100),
`extra3` varchar(100),
`extra4` varchar(100),
`extra5` varchar(100),
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

Custom profile fields must be named extra1, extra2, extra3 etc! What does that mean please?

Cheers
BB

[Pablo]

It means that the database fields and input fields need to be named like this. You cannot pick random names.

[bburgess]

It means that the database fields and input fields need to be named like this. You cannot pick random names.

Thanks Pablo

I thought that is what it meant, but wanted to be sure, is this because its tied in with the PHP?

Cheers
BB

[Pablo]

No, it is because all names (database fields, input field, scripts, admin tool) need to match.

[bburgess]

No, it is because all names (database fields, input field, scripts, admin tool) need to match.

Thanks Pablo at some stage I will get to go through the tools code and not ask you dumb questions

Have a great day!

Cheers
BB