Help on returning array values

[neilfurry]

Hello Mate,

 

I have another problem, though i already fixed the problem on my previous post, i came across on another problem.

 

i have this code:

$sql = mysql_query("SELECT * FROM schedules") or die(mysql_error());

$results = array();
    while($rs=mysql_fetch_array($sql)){
                $results['events'] = array([
                    
                    'id'    =>    (int)$rs['id'],
                    'start'    =>    $rs['date_start'],
                    'end'    =>    $rs['date_end'],
                    'title'    =>    $rs['details'],
                    'free' =>    (bool)$rs['isfree'],
                    'userId' => (int)$rs['techID'],
                    'color'    => render_color_code($rs['zip'])
                ]);
    }

 

I have  many events on my database, but only one is being displayed using the script above. how can i make it so that this script will get all events from my database. can you check what is wrong with my coding?

 

Cheers!

Neil

 

[requinix]

You're overwriting $results['events'] every time. What you should do is start with "events" as an array and then add to it.

 

$sql = mysql_query("SELECT * FROM schedules") or die(mysql_error());
$results = array('events' => array());
    while($rs=mysql_fetch_array($sql)){
                $results['events'][] = array(
                    
                    'id'    =>    (int)$rs['id'],
                    'start'    =>    $rs['date_start'],
                    'end'    =>    $rs['date_end'],
                    'title'    =>    $rs['details'],
                    'free' =>    (bool)$rs['isfree'],
                    'userId' => (int)$rs['techID'],
                    'color'    => render_color_code($rs['zip'])
                );
    }

And you're nesting your arrays wrong. array([]) will put an array inside another array. Use either the array() or [] syntax to get just the one array.

[neilfurry]

Thanks mate, i just get it working... :-) cheers

 

Neil