2.3. Building a Recipe Website with MySQL

In our example, we’re going to build a recipe website presenting dynamic content to the user. First, we’ll need to create a database; let’s call it “recipes.” Next, we can create a couple of tables with which to populate our database and contain the content our site will present. For a start, let’s have a table to hold all our recipes, and another one containing recipe categories. Figure 2-1 gives a picture of how our basic table structure will look.