how i can group a table to make charts
i want to make charts system and i think it must be grouping like this
1 jan 2009 = 10 post 2 jan 2009 = 2 post 4 jan 2009 = 10 post 6 jan 2009 = 60 postand i have posts table that has id,user_id,date how i can select from posts to show it like that and the date type is UNIXTIME
1 Answer
Try ..
SELECT FROM_UNIXTIME(`date`, '%e %M %Y') as `post_date`, COUNT(*) FROM your_table GROUP BY `post_date`More information to reference: Posted: MacOS 1 of 1 people found this answer helpful. Did you? Yes No |
© Advanced Web Core. All rights reserved