Database entries

[neroag]

Hi all
Im not sure where to start with this one ...
I have a loop for getting array data ..(category, subcat1, subcat2, subcat3)

I need to insert these into a database table with separate ids
ie ..

category1 id1

now the tricky part subcat1 needs its own id but will also need to include the root categories id as above, so the subcat is related to the category in the same array it came from

I havent a clue where to start so any pointers appreciated

thanks

[johanafm]

Normalize your schema, and here's why.
Then simply use auto_increment for the subcat table and have the category id as a foreign key of this table.