create db with following

[mc136]

Hi I seem to manage to produce the info i need when not using a database. Being new to mysql could someone help in telling me how i should enter the following data into db.

 

$section['servicedesk']['batch'] = 8;

$section['servicedesk']['promo'] = 22;

$section['servicedesk']['ens'] = 2;

$section['status']['fmr'] = 16.00;

$section['status']['odw'] = 16.00;

 

print_r ($section);

 

returns the following:

 

Array ( [servicedesk] => Array ( [batch] => 8 [promo] => 22 [ens] => 2 ) [status] => Array ( [fmr] => 16 [odw] => 16 ) )

[fenway]

What do these represent?

[mc136]

hi servicedesk and status represent sections (headings) and for each i need to be able to enter approp info

i.e. servicedesk contains sub directory batch, promo and these contain the values whatever 6, 7, etc

 

e.g. Servicedesk

          batch - 8

          promo - 2

 

      status

          fmr - 3

          odw - 5

 

[fenway]

I'm still confused -- you just want to make tables for these objects?

[artacus]

Without really having a clue what you're doing. I'd strongly recommend something like so:  

 

Servicedesk

-- service_id INT AUTOINC

-- batch INT

-- promo INT

-- ens INT

 

Status

-- service_id INT

-- frm DECIMAL(5,2)

-- odw DECIMAL (5,2)