table not taking date

[harlequeen]

I have 3 tables in a database
1 - Guests,
2 - Bookings
3 - Rooms

The rooms table only really contains room type information either D, S, F. Room type is the primary key, the only other thing in there is foreign keys linking to booking and guest id.

The problem I have is that the table will only accept one each of room type D, S, F and then rejects all others.

How can I get it to accept duplicate values for this field?

Cheers

[devinemke]

what is the exact data structure of your db? post the table creation SQL if possible.

[harlequeen]

I came back to update my thinking on this. I cannot post the sql structure as I have dropped the table now in order to make changes.

I have amended my rooms table to include an auto-increment field which could be the primary key, so that the room type field would not need to be unique.

But doing this has caused me other problems because I am using

mysql_insert_id() and LAST_INSERT_ID()

to get the auto-incremented field from the Bookings table. I cannot get the correct bookings number now.

I am doing this as a learning project, so want to keep 3 tables, even though, strictly speaking, I could include the room type in the bookings table.