select * WHERE date = 109649880 (time stamp)

[Paul_Ferrie]

I am trying to breakup data returned form a mysql query.
I have a database "worklines"
int ther i have the table "noLines"

ddpID
ddpDate
ddpCount

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

[devinemke]

$result = mysql_query('SELECT * FROM worklines ORDER BY ddpDate');
while ($row = mysql_fetch_assoc($result))
{
	$year_month = date('Y-m', $row['ddpDate']);
	$worklines[$year_month][] = $row;
}
echo '<pre>' . print_r($worklines) . '</pre>';

you now have an multi-dimensianl array $worklines that is broken down into individual months as subarrays

[Paul_Ferrie]

Fantastic,
that looks along the lines as i was trying to do

Cheers

[Paul_Ferrie]

Hi again.
I tried your code and it work just like you said it would. How do i go about accessing this data in the array?

Here's what i am trying to accomplish.

I want to pull available months from the database
The months will be loaded into a flash movie (buttons)

monthID with be the timestamp relevent to month

button 1 = month 1
button 2 = month 2
and so on.

Now when a user clicks on one of the months
Another script will pull the available weeks and display them as a DDmenu underneath the month

weekID will be relevent month and week relevent to timestamp

button1 = week 1
and so on

Now when the user clicks on the week this will load the 5 working days of that week
I hope you have followed that ok

Cheers for any help
Paul

[devinemke]

rather than pulling all of that data initially, i suggest you selectively only grab the data you need for each button. lets say the user chooses "June 2004" then you query would be:

SELECT * FROM worklines WHERE MONTH(FROM_UNIXTIME(ddpDate)) = '6' AND YEAR(FROM_UNIXTIME(ddpDate)) = '2004'

if ultimately the user only wants to see the records from a certain month/week/day then only pull those records.

[Paul_Ferrie]

This should give a good picture if what i am trying to accomplish. The buttons dont work yet nor the graph data.
http://www.innovativedesigns.org.uk/test/lines.html

[Paul_Ferrie]

bump

[Paul_Ferrie]

Hi guys merry x-mass and a happy new year😃
I decided to shelve this after getting no were fast. once again i found myself thinking about finishing it.

Can i get a couple of things clarified:

What field type should the row be that is holding the date
How should i set date when data is being added, currently i have($aahDate= time()😉

Whats the query to pull the specific months from the db

Cheers
Paul