[SOLVED] Array Help

[adam291086]

This is how my array looks when printed

 

Array ( [1] => Array ( [4] => Hit james ) ) Array ( [1] => Array ( [4] => Hit james ) [2] => Array ( [4] => Hit james [5] => Put james in hospital with a broken arm ) ) Array ( [1] => Array ( [4] => Hit james ) [2] => Array ( [4] => Hit james [5] => Put james in hospital with a broken arm ) [3] => Array ( [4] => Hit james [5] => Put james in hospital with a broken arm [10] => Put James in hospital with a dislocated knee ) )

 

This is how i created the array

 

include 'config.php';
$result = mysql_query( "
SELECT * 
FROM `table` 
WHERE `Month` = $thismonth  AND `Year` = $thisyear") 
or die('Query failed. ' . mysql_error());
$arrDays = array();
$arrEvent = array();
while($row = mysql_fetch_array($result))
{  
$id = $row['ID'];     
$arrDays[] = $row['Day'] ;     
$Month = $row['Month'] ;     
$Year = $row['Year'] ; 
$arrEvent[$row['Day']]  = $row['Event Details']; 
$arrBig[$row['ID']]  = $arrEvent; 
print_r($arrBig);
}  

 

This is the problem

 

I want to echo the information for example when the day = 5. The reason the id is also in the array is because some days have multiple bits of information so the id makes the array unique. I can do this without the id in the way. But i am not confused?

 

Any help is appreciated. I think i may of set the array up wrong

[rajivgonsalves]

I think you setup the array all wrong  , its hard to tell what is what just looking at the array output...

[adam291086]

how do i set it up. I need an array to store the event id and the event day. This is for my calendar

[adam291086]

ok i have chaged the array to

 

Array ( [4] => Hit james ) Array ( [4] => Hit james [5] => Put james in hospital with a broken arm ) Array ( [4] => Hit james [5] => Put james in hospital with a broken arm [10] => Put James in hospital with a dislocated knee )

 

while($row = mysql_fetch_array($result))
{  
$id = $row['ID'];     
$arrDays[] = $row['Day'] ;     
$Month = $row['Month'] ;     
$Year = $row['Year'] ; 
$arrEvent[$row['Day']]  = $row['Event Details']; 
print_r($arrEvent);
}  

 

This works fine. I need to make each entry unique so when there is two entries for the same day both are displayed.

[rajivgonsalves]

your code should be

include 'config.php';
$result = mysql_query( "
SELECT * 
FROM `table` 
WHERE `Month` = $thismonth  AND `Year` = $thisyear") 
or die('Query failed. ' . mysql_error());
$arrDays = array();
$arrEvent = array();
while($row = mysql_fetch_array($result))
{  
$id = $row['ID'];     
$arrDays[] = $row['Day'] ;     
$Month = $row['Month'] ;     
$Year = $row['Year'] ; 
$arrEvent[$row['Day']][]  = $row['Event Details']; 
}  

 

then just use a implode on $arrEvent , if I remember correctly your code it should be

 

 

implode("<BR>",$arrEvent[$i]);

[adam291086]

thank you so much. I now understand after some more reading on arrays