this is my code
$customer->where(DATE_FORMAT(month,'%m')=date('m',strtotime('+1 month')));
how to get next month name ,i have try it. but i got the error this Can't use function return value in write context
Just do this, You can get the next month from here and use it in where you want.
$next_month = date('F',strtotime('next month')); // June
If you know the name of the last month then use-
$next_month = date('F',strtotime('June next month')); // July