array_push help

[abda53]

im having issues with this. i am trying to get the results for this to show up like this..

MONTH
event 1
event 2
event 3

MONTH
event 1

MONTH
event 1
event 2

etc

mysql_connect($host,$uname,$pass);

@mysql_select_db($dbase) or die( "Unable to select database");

$query="SELECT * FROM `events` ORDER BY date ASC;";
$result=mysql_query($query);

$num=mysql_numrows($result);
for ($i=0;$i < $num;$i++) {
$event=mysql_result($result,$i,"event");
$date=mysql_result($result,$i,"date");

$date_array = explode("-",$date);
$year = $date_array[0];
$month = $date_array[1];
$day = $date_array[2];
$events_array = array();

array_push($events_array, [$month,[$event]]);  /////  <----------------

echo 's'.sizeof($events_array)."<br>";

}

foreach ($events_array as $month => $monthevents){
	echo $month."<br>";
	echo $monthevents;
	foreach ($monthevents as $event){
		echo $event."23231<br>";
	}	
}

mysql_close();

[brandtj]

Your problem may be a result of:

$num=mysql_numrows($result);

Which should be:

$num=mysql_num_rows($result);

[abda53]

ok ive been working on this trying to troubleshoot the problem.

so far i have

<?php
mysql_connect($host,$uname,$pass);

@mysql_select_db($dbase) or die( "Unable to select database");

$query="SELECT * FROM events ORDER BY date ASC;";
$result=mysql_query($query);

$num=mysql_num_rows($result);
for ($i=0;$i < $num;$i++) {
$event=mysql_result($result,$i,"event");
$date=mysql_result($result,$i,"date");

$date_array = explode("-",$date);
$year = $date_array[0];
$month = $date_array[1];
$day = $date_array[2];
$events_array = array();

array_push($events_array, "$month", "$event");

print_r($events_array);
echo "<br>";
}

foreach ($events_array as $month => $monthevents){
echo "month: ".$month."<br>";
echo "month events: ".$monthevents."<br>";

foreach ($monthevents as $event){
echo "event = ".$event."<br>";
}

}

mysql_close();
?>

and that outputs

Array ( [0] => 04 [1] => This is event 4 )
Array ( [0] => 04 [1] => This is event 3 )
Array ( [0] => 06 [1] => This is event 1 )
Array ( [0] => 07 [1] => This is event 2 )
Array ( [0] => 09 [1] => This is event 5 )
month: 0
month events: 09
month: 1
month events: This is event 5

and the database looks like

id - date - event
ID 10: 2006-04-09 - This is event 4

ID 9: 2006-04-13 - This is event 3

ID 7: 2006-06-09 - This is event 1

ID 8: 2006-07-06 - This is event 2

ID 11: 2006-09-18 - This is event 5

[abda53]

found the problem

$events_array[strftime('%B', strtotime($date))][] = $event;