play with array?

Anon

Hi,

I have a sorted array with dates (format: yyyy-mm-dd).

What I need is create seperate arrays. Each array should contain all dates within the same month.

example:
$array = ("2001-12-01","2001-12-06","2002-01-01","2002-01-07","2002-02-01","2002-02-11");

arrays:
$array1 = ("2001-12-01","2001-12-06");
$array2 = ("2002-01-01","2001-01-07");
$array2 = ("2002-02-01","2001-01-11");

What is the quickes way to get there?

Thanks,
Raoul

Anon

sorry guys,

the result arrays should look like this!

arrays:
$array1 = ("2001-12-01","2001-12-06");
$array2 = ("2002-01-01","2002-01-07");
$array3 = ("2002-02-01","2002-01-11");

Raoul

van__

Well, that looks like a bunch if fun.
I believe you might be able to just create the actualy effects while you create the array.

But, since I don't have your source in front of me, I'll assume that you did in fact have no other choice but to twice loop through an array as I know there are times when it is unavoidable.

So ....

$array = array ("2001-12-01","2001-12-06","2002-01-01","2002-01-07","2002-02-01","2002-02-11","2002-03-16");

for($i=1;$i<=12;$i++) {
if ($i<10) { $i = "0".$i; }
for($x=0;$x<count($array);$x++) {
if (ereg('[0-9]{4}-'.$i.'-[0-9]{2}',$array[$x])) {
$sorted[$i][count($sorted[$i])] = $array[$x];
}
}
}

//sorted now contains all 12 months and all dates found for each month, sorted by month.
print_r($sorted);

//call this month like so..
foreach($sorted[date('m')] as $key=>$val) {
echo $key . ": " . $val;
}

van__

Actually, now that I've answered your question on "playing with array" and stopped assuming that you were forced to do that as the only reasonable method, I believe that you are in fact being wasteful with the power of SQL, since the only time I would ever have a value of YYYY-MM-DD is from a SQL SELECT.

You can have MySQL return your results all ready ordered for you and ready to go by simply using the following syntax:

$sql = "SELECT * FROM myTable WHERE ... ORDER BY UNIX_TIMESTAMP(datetimeColumnName)";

And presto, your result set will be ordered by the date in accordance to it's sequence based on year month and day. Eleminating the need to waste resources and code on looping through your result set and thereby creating a faster loading page.

Anon

you're right Van, the example I gave is just to give the idea.

The date is coming from a sql database and is already sorted.

What I need is create individual arrays for each set of rows that have the same month in the sql table. Just as given in the example.

I am just beginning with php but this seems to work fine:

foreach($array as $arrayItem){
${"array".substr($arrayItem,5, 2)}[]=$arrayItem;
}

Is this 'ok' code?

Thanks,
Raoul