Web Design

305

CHAPTER

Adding Information from a Database 13

Can I create pages that contain more than one

query?

Yes. You can repeat the code to create the query as

many times as you want. You only need to ensure

that each query uses a different variable name. You

also need to run each query separately, through

repeated calls to the mysql_query function.

Do SQL keywords such as SELECT and FROM have

to be capitalized?

No. SQL is case-insensitive. Many database

developers capitalize the keywords to make them

stand out and make the query easier to read, but

the query functions properly if the keywords are not

written in capital letters.

6 Type ?>.

The query is created and
added to the page.

5 Type $data = mysql_
query($query);.

5

6

TIPS