B.2. MySQL Statements

In this section we consider the SELECT, INSERT, and UPDATE statements we use with the ContactManager in Chapter 16 and Chapter 17. It’s important to realize that we’ll be submitting these statements later via PHP as query strings, so while we’re showing them here as pure SQL statements, they won’t necessarily read so smoothly in PHP, which will require concatenating them.

B.2.1. The SELECT Statement and Fully Qualified References

Example B-1 shows the SELECT statement called by ContactManager that will be used to initially load as well as refresh the list of contacts whenever the database is changed.