PHP MYSQL: Display Data in Combobox

Hi there! Today I am going to create a database-driven combobox/dropdown menu. I will display all records from the CATEGORY table into a com...

PHP INSERT INTO: Add New Record Into A Database

Data is essential in an organization. So storing it in a database helps an organization to easily store it so they can retrieve it in the ne...

SQL JOIN: Display Records With or Without Match on The Other Table

There will be cases where you want to join two (2) table and display records that has match or even without match on the other table. Table ...

SQL NATURAL JOIN: Display Records That Have Match on the Other Table

Let's say we have two (2) table, the STUDENT and GRADE table and we are going to display all students with grades only. We'll exclud...

SQL ORDER BY: Display Records in According to Date and Time in Descending Order

ORDER BY is the keyword used to arrange records either in ascending (which is the default ordering if not set) or descending order. If you a...

SQL NOT IN: Display Records That Are NOT IN Another Table

Let's say you want to display the records from the left table which is the ENROL table  which are NOT IN the right table which is the SU...