I am trying to breakup data returned form a mysql query.
I have a database "worklines"
int ther i have the table "noLines"
The date will be set with "date();"
So this will store 109649880 in the database
i will have 100 plus rows in the table
i want to breakdown the data returned in order of months
so month 1 would return the 4 weeks for that month and so on for each month after
I think the query would be something like:
mysql_query="SELECT * FROM worklines WHERE ddpDate=109649880;
// and so on for each month
my problem is setting up each time stamp for each month.
I hope you get the picture