Intermediate MySQL tutorial

Once you have used the basics of PHP and MySQL you may want to try some of these pages.

Hover over the links for a brief description.

  1. Displaying MySQL data in HTML tables
  2. Displaying MySQL data in HTML tables with styles
  3. Creating links from MySQL data
  4. Creating drop down lists from MySQL data
  5. Multiple WHERE conditions
  6. JOINing data from two tables
  7. MySQL JOIN and three or more tables
  8. MySQL DISTINCT
  9. MySQL GROUP BY
  10. SELECTing specified fields in MySQL
  11. MySQL arithmetic
  12. Using MySQL with dates
  13. Using ticks in queries
  14. MySQL security
submit to reddit Delicious Tweet