Listing Options

[jhanna]

I need to create options for all my listings.
Example:
All the listings have the following fields:
link_id
tile
description
...

Now, there is a variable that needs to be added to each link and that variable has 4 fields, so I created a table in the db like:

CREATE TABLE `idx_options` (
`option_id` mediumint(9) unsigned NOT NULL auto_increment,
`link_id` mediumint(9) unsigned NOT NULL default '0',
`optiontype` varchar(255) default NULL,
`yard` varchar(255) default NULL,
`rating` varchar(255) default NULL,
`slope` varchar(255) default NULL,
KEY `option_id` (`option_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


I can not simply use the idx_links table, because each listing might have from one to 5 options.

Now, I want to implement these options on the ad link page.
Can someone please tell me if there is a mod for this or a way to accumplish this?


Thanks so much

[esm]

Now, I want to implement these options on the ad link page.
Can someone please tell me if there is a mod for this or a way to accumplish this?

Being the lazy sod that I am and based on what you say, I would just add it using HTML in the add_form.html file.

modify_form.html would be a different matter.



.

[dody]

With 5.1.0 you can easily create custom field for dropdown, radio button, multiselect, and many more.

[mycolumbus]

Can you please explain where to go in order to create a custom field? Can't find it anywhere in the control panel.

Thank you.

[mycolumbus]

Just found the answer:

Go to Admin Panel > Database > Alter
You can add your custom field from there.