Don't be Afraid of Source Code
Data can be grouped by “group by” key-word.
|
1 |
group by FieldName; |
tbllibrary table structure and current status of the tbllibrary.
|
1 |
select * from tbllibrary; |
Group by the writer and count the records for each writer.
|
1 |
select writer, count(*) from tbllibrary group by writer; |
Explanation
There are four groups by “writer” in the table “tbllibrary”;
Anuj Kumar
Hi! I am Anuj Kumar, a professional web developer with 5+ years of experience in this sector. I found PHPGurukul in September 2015. My keen interest in technology and sharing knowledge with others became the main reason for starting PHPGurukul. My basic aim is to offer all web development tutorials like PHP, PDO, jQuery, PHP oops, MySQL, etc. Apart from the tutorials, we also offer you PHP Projects, and we have around 100+ PHP Projects for you.
