how can add new field by db code

[al3bed]

you are great Lynne

thanks a lot

--------------- Added [DATE]1234846546[/DATE] at [TIME]1234846546[/TIME] ---------------

I have another problem

if I want to delete these rows I will use this:

PHP Code:

$db->query_write("
            DELETE FROM " . TABLE_PREFIX . "profilefield 
            WHERE profilefieldid = " . $id
            );
        
$db->query_write("
            DELETE FROM " . TABLE_PREFIX . "phrase
            WHERE fieldname = 'cprofilefield' AND
            varname IN ('field" . $id . "_title', 'field" . $id . "_desc')
        "); 


but it's not working?!

is that becuase $id is not recognized ? cause the first code in install code section and this one in uninstall code ?