The following table and its data is being pulled from a mySql database that I created called contacts. This is a sortable display where a user can either select to filter by State and can sort by either ID, First Name, Last Name or State when they click the link in the column heading.
| ID | First Name | Last Name | Phone | State | Description | |
|---|---|---|---|---|---|---|
| 1 | Bob | Smith | bsmith@donotreply.com | 123-4567 | WA | My long lost friend |
| 2 | Sally | Smith | ssmith@donotreply.com | 333-4545 | OR | Good old friend from High School |
| 3 | Mike | Philips | mphilips@donotreply.com | 888-6677 | ID | Buddy from work |
| 4 | Tracy | Williams | twilliams@donotreply.com | 999-4411 | AZ | Classmate from dental school |
| 5 | Connie | Price | cprice@donotreply.com | 223-5555 | WA | Friend I met traveling in Europe |
| 6 | Jack | Lewis | lewisinteractive@gmail.com | alphanumeric | WA | ya know, its me, Vince |
| 7 | James | Kirk | jamesk@noreply.com | 555-555-5555 | CO | "he's dead Jim" |
| 8 | Shake | Spear | shakespear@notarealemailadress | (555)SKSPEAR | WY | To be or not to be, That is the question. Whether tis' nobler in the mind to endure the slings and arrows of unbearable fortune or... |
| 9 | Lynn | Edgington | Lynnskey@gmail.com | 555-1212 | WA | Have a great summer! |
SQL Query: SELECT * FROM contacts