WS101 Assignment#2

Edit Answers
12345678910111213141516
Across
  1. 3. it is an SQL statement that is used to insert new rows in a database table
  2. 4. it is an SQL statement that is used to delete rows in a database table
  3. 8. a function that can be used to include a php file in another one
  4. 12. BY a clause that lets you define the field name to sort against and the sort direction either ascending or descending
  5. 13. it is an SQL statement that is used to select the records from database tables
  6. 14. a function that closes a database connection or a query
  7. 16. a function that gets a result set from an executed query
Down
  1. 1. a clause to apply the changes to only those records that matches specific criteria
  2. 2. a function that binds the parameters to the SQL query and tells the database what data type the parameters are
  3. 5. a function that executes a given query
  4. 6. a function that checks if there are more than zero rows returned
  5. 7. a function that puts all the results into an associative array that we can loop through
  6. 9. it is an SQL statement that is used to change or modify the existing records in a database table
  7. 10. it is used to execute the same (or similar) SQL statements repeatedly with high efficiency
  8. 11. allows you to access MySQL database servers
  9. 15. an operator that is used in a WHERE clause to search for a specified pattern in a column