get value into array

[Lassie]

I have a sql query  that gets all the events from a specified month and should put the values into an array.print _r shows the values are being pulled from the database.

I can't get this to work.

Any suggestions appreciated.

Code

$events = array();

global$wpdb;

 

echo $month;

echo $year;

 

$query=("SELECT title, DATE_FORMAT(event_date,'%Y-%m-%e')AS event_date FROM sw_appointments  WHERE YEAR(event_date) = $year AND MONTH(event_date) = $month");

 

$result = $wpdb->get_results($query,ARRAY_A);

print_r($result);

foreach( $result as $results ) {

        

        $events=$results->event_date;

        echo $events;

        

 }

    

[Ch0cu3r]

To add each event_date to to the $events array you'd use

foreach( $result as $results ) {
   $events[] = $results['event_date'];
}

Alternatively you could just do

$events = $wpdb->get_results($query,ARRAY_N);

[Lassie]

Hi, thanks

This gives me

Array ( [0] => [1] => [2] => )

Should I see the values?

[Ch0cu3r]

Try my code again as I had an error in my code when I posted it.

 

Also post the output of

print_r($result);

[Lassie]

That outputs

Array ( [0] => Array ( [title] => Viewing [event_date] => 2014-01-7 ) [1] => Array ( [title] => Viewing [event_date] => 2014-01-16 ) [2] => Array ( [title] => Viewing [event_date] => 2014-01-16 ) )

[Lassie]

Ok

print_r $events is

Array ( [0] => 2014-01-7 ) Array ( [0] => 2014-01-7 [1] => 2014-01-16 ) Array ( [0] => 2014-01-7 [1] => 2014-01-16 [2] => 2014-01-16 )

I have I got too many arrays? Drop ARRAY_A maybe?

[Lassie]

Dropping ARRAY_A gives fatal error

[Ch0cu3r]

That outputs

Array ( [0] => Array ( [title] => Viewing [event_date] => 2014-01-7 ) [1] => Array ( [title] => Viewing [event_date] => 2014-01-16 ) [2] => Array ( [title] => Viewing [event_date] => 2014-01-16 ) )

 

then

$query=("SELECT title, DATE_FORMAT(event_date,'%Y-%m-%e')AS event_date FROM sw_appointments  WHERE YEAR(event_date) = $year AND MONTH(event_date) = $month");
 
$results = $wpdb->get_results($query,ARRAY_A);

$events = array();
foreach( $results as $result ) {
        
        $events[] = $result['event_date']; 
}

printf('<pre>%s</pre>', print_r($events, true));

Should work fine.

[Lassie]

Thank you.

Outputs

Array
(
[0] => 2014-01-21
[1] => 2014-01-7
[2] => 2014-01-16
[3] => 2014-01-16
)