How Can We Calculate Mysql Table´s Rows Item Group By Month Of More Than 5 Years?

I have like more than 5 years record in our database. And I want to calculate them through group by month. Unfortunately, when i try to using sum() function it just shows me the result of one year. but I need to calculate the sum of more than 5 years record group by month [...]

How To Seperate Table´s Field Value(varchar, Num) In Mysql?

i have a table´s field called client_id(varchar) actually, there are some result having num value(i.e 0012) which is a foreign key to crm_employee_bs(i.e. id) table and some result having char value(i.e joey) which is also a foreign key to crm_employee_bs(i.e. username) table.

Open Source Crm/erp In Php And Mysql?

Which is the best available open source crm/erp in php and mysql? I want to implement that in my company with the ability to edit the source code according to our needs