CIST 2550 PHP Chapter 18

Teresa Stillings

Exercise 18-1a (#4) Work with the data in a database. SELECT statements.

Exercise 18-1b (#4 cont.) Work with the data in a database.SELECT statements.

Exercise 18-1c (#5) Work with the data in a database. SELECT statement. INNER JOIN.

Exercise 18-1d (#7) Work with the data in a database. Creating SELECT statements.

Exercise 18-1e (#7 cont., #8) Work with the data in a database. Creating SELECT statements, INNER JOIN.

Exercise 18-1f (#9, #10) Work with the data in a database. Creating COUNT(*) function with subquery, INSERT statement.

Exercise 18-1 (#11, #12) Work with the data in a database. Creating UPDATE, DELETE statements.