help needed in the database

[Khadija.A]

Hi all,

I am working on an application that is designed using php and currently I have to do some database modifications.

 

Here is a screen shoot of the page that includes the field that needs to be modified:

 

 

 

Under the Block/ Room list there are the following values (which are coming from the database (specifically the “products” tables) :

Block A

Block B

Block C

Block D

 

Here is the structure of the products table:

 

 

Now I need to add the rooms in the same list as the following:

Block A

A01

A02

A03

….

Block B

B01

B02

….

Do I have to create another table? If yes what fields should go in there? Do you have another idea on how to achieve the same thing?...

 

 

[fenway]

I don't understand.