Php – Database design for a booking application e.g. hotel

mysqlphp

I've built one, but I'm convinced it's wrong.

I had a table for customer details, and another table with the each date staying (i.e. a week's holiday would have seven records).

Is there a better way?

I code in PHP with MySQL

Related Question