Do anyone know how to add extra field into the sql table of xoops...I like it to add the extra field i create when installation.

For example to add a extra field for country:

when i try to insert the code into XOOPS sql

country varchar(100) NOT NULL default <====this do not work...

Also, how to insert extra field into table after the table is created? pls let me know the sql command to do so...thks

Here's an example:



What tool are you using to execute the query?

thks...I using phpmyadmin

I'm also interested in doing this. I want to add a drop down menu full of all the counties of the UK when using the MyAlbum modules. On the page where people submit pictures and add a description, I want the drop down menu to appear in there for the user to select, and of course this needs to be connected to the database.

Can anyone tell me how to do that? I'll also need to know how to update the html side of things so that the menu is displayed. Is there somewhere I should read that would tell me this or is it actually really simple?

Would I be best starting a seperate post? I think the two are so closely linked I don't think two seperate one's are necessary, but still....

Thanks

Ted

**bump**