passing query results into $data array

[eluser]stef569[/eluser]
Hi, I'm trying to put values from one row into the view.

Code:

$sql = 'SELECT user_name, event_Bday, event_EDay FROM events,users WHERE event_id = ? AND events.user_id = users.user_id';
$query = $this->db->query($sql, array($event_id));
$data['row'] = $query->result_array();

But when I use the following code in the view:

Code:

echo $row['event_Bday'];

then I get the following error:

Message: Undefined index: event_Bday

a print_r of $data returns

Code:

Array ( [row] => Array ( [0] => Array ( [user_name] => Angela [event_Bday] => 2 [event_EDay] => 9 [event_Bmonth] => 11 [event_Emonth] => 11 [event_year] => 2007 ) ) [heading] => Bekijk een Event ) Data: 1

heading is accessable.
row will always contain only one row