TAG = mysql

How to use LEFT JOIN in MySQL

Author: Patrick Morrow

If you need to retrieve related records from more than one table in a MySQL database then the use of a LEFT JOIN may be the answer.

Read More mysql

How to find the sum of values in a MySQL table field

Author: Patrick Morrow

Recently I needed to find the sum of all values in a particular field within a MySQL table. This is how I went about doing it.

Read More mysql

Learn PHP, PDO, phpMyAdmin and MySQL

Author: Patrick Morrow

Are you a beginner wanting to learn how to code? Do you want to learn PHP and how to connect to a database? We have the course for you!

Read More php html bootstrap pdo mysql course

Multiple Dropdown Lists Using jQuery Ajax and PHP

Author: Patrick Morrow

In this tutorial we will populate a dropdown list based on the value of another dropdown list. This is commonly used for countries and states.

Read More mysql pdo css bootstrap jquery html php

How to Create a jQuery Ajax and PHP Autocomplete Script

Author: Patrick Morrow

In this lesson we will create an autocomplete script using jQuery and PHP. Autocomplete fields can be extremely useful for searching through database records and making suggestions to the user.

Read More php html jquery css pdo mysql

PHP for Beginners

Would you like lifetime access to the hugely successful PHP for Beginners course? Click here to find out how.

FREE Code Snippets

FREE hints and tips delivered direct to you once per month.