Basic Database Help Needed

Insert New Field

[Edge]

I'm clueless...

I need to modify an existing database table called "jb_jobs" by adding a new field "appox_salary_range".

I have PHPMYadmin, however I have only used it to perform backups and restores.

I have MySQL - 4.0.20 and am running phpMyAdmin - 2.8.0.3.

Thanks in advance

[phranque]

select the db name, then the table name.
columns are displayed to the right.
below the column display there is a row where you can add a new field at the beginning/end of the table or after a specified column.

or you can use the mysql command line interface:

ALTER TABLE jb_jobs ADD `appox_salary_range` varchar(255) default NULL;

or use "float" instead of "varchar(255)" if appropriate...

[Edge]

Thanks!, it seems to have worked!