<div>
I think you can use a GROUP BY with COUNT()
</div>


I think you can use a GROUP BY with COUNT()

<div>
Thanks for the points. &nbsp;Here is line 117 deconstructed:<br />
<br />
/* Get me the column named fname and the count of the id column. &nbsp;Name the count &quot;num&quot; in the results set */<br />
SELECT fname, COUNT(id) as num FROM my_table <br />
<br />
/* Group all matching fname columns together, and order the results set alphabetically */<br />
GROUP BY fname ORDER BY fname<br />
<br />
<br />
Best regards, ~Ray
</div>


Thanks for the points.  Here is line 117 deconstructed:

/* Get me the column named fname and the count of the id column.  Name the count "num" in the results set */
SELECT fname, COUNT(id) as num FROM my_table

/* Group all matching fname columns together, and order the results set alphabetically */
GROUP BY fname ORDER BY fname


Best regards, ~Ray

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have this table<br />
<br />
cars<br />
dogs<br />
cars<br />
dogs<br />
cats<br />
tables<br />
electronics<br />
tables<br />
tables<br />
electronics<br />
<br />
and so on...<br />
<br />
I need a query and &nbsp;php code to give a table that presents the unique values and count how many exists of each of them, like a pivot table in excel<br />
<br />
cars &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<br />
dogs &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
cats &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
tables &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
electronics &nbsp;2 &nbsp;<br />
<br />
any idea?
</div>
</div>


Hi,

I have this table

cars
dogs
cars
dogs
cats
tables
electronics
tables
tables
electronics

and so on...

I need a query and  php code to give a table that presents the unique values and count how many exists of each of them, like a pivot table in excel

cars              2
dogs             2
cats              1
tables           3
electronics  2  

any idea?

SQL and php to count rows and in a table and summarize in another table

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.