Last updated on May 26th, 2016 at 11:28 am
Count distinct records using MySQL PHP
This tutorial shows you how to count unique records with MySQL and display it using PHP.
This line
count(<COLUMN_NAME>) AS count_me
simply means that the count value is assigned to variable count_me and we can ECHO it using
$row['count_me']
Complete code is displayed below. Here i am using connect.php which contains the usual connecting logic to MySQL.
{column_name} refers to your COLUMN NAME
{table_name} refers to your TABLE NAME
include("connect.php");
$sql = "SELECT <COLUMN_NAME>, count(<COLUMN_NAME>) AS count_me FROM <TABLE_NAME> GROUP BY <COLUMN_NAME>";
$rsd = mysql_query($sql)or die("None");
while ($row = mysql_fetch_array($rsd))
{
echo $row['<TABLE_NAME>']."(".$row['count_me'].")<p>";
}
This is the simplest code to select and display records from MySQL database table and display in PHP.
$cn=mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
mysql_select_db($db_name,$cn) or die(mysql_error());
$sql = “SELECT field_name FROM table_nameâ€;
$rs = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($rs)){
echo $field_name = $row[“field_name”];
echo “â€;
}
mysql_free_result($rs);
Thanks for the post, No links allowed here please submit links or tutorials you have using our http://mistonline.in/wp/submit-script/ option.
Great tutorials. Really helpful information.
Thanks for publishing.