How to count distinct records in MySQL using PHP
This tutorial shows you how to count unique records inside MySQL table and display it using PHP.Use the below SQL query to count the column SELECT UPDATE_TIME, count(UPDATE_TIME) AS count_me…
This tutorial shows you how to count unique records inside MySQL table and display it using PHP.Use the below SQL query to count the column SELECT UPDATE_TIME, count(UPDATE_TIME) AS count_me…
This tutorial will show you how to display mysql tables using for loop instead of while in php. We are using mysqli_num_rows to get the number of rows and using…
Very simple query to find out the sum of multiple fields inside a mysql table.Lets say we have 2 numeric columns , COL1 and COL2 then the mysql query to…
This script will show you how to take complete MySQL database backup by running the PHP script. Then Email the backup file as an attachment. Steps involved Take complete MySQL…