[SOLVED] Array help please

[Calver]

Hello, I was very pleased to get a row of data from my database into an array, but I can't find out how to access it.

 

This is what I get from: var_dump($this->row);

 

array

  0 =>

    array

      'id' => int 1

      'firstname' => string 'Samuel' (length=6)

      'lastname' => string 'Cross' (length=5)

      'username' => string 'sammy' (length=5)

      'password' => string '47bce5c74f589f4867dbd57e9ca9f808' (length=32)

      'emailadd' => string 'sammy@somedomain' (length=16)

      'about' => string '' (length=0)

      'status' => int 1

      'activationkey' => string '' (length=0)

 

How do I retrieve a specific field, eg $firstname = ?

 

[p2grace]

Use this method instead:

 

$arr = mysql_fetch_assoc($query);
$firstName= $arr['firstName'];

 

http://us.php.net/manual/en/function.mysql-fetch-assoc.php

[Alex]

echo $this->row['firstname']; // Samuel

[Calver]

Use this method instead:

 

$arr = mysql_fetch_assoc($query);
$firstName= $arr['firstName'];

 

Thank you, but I'm using mysqli with prepared statements. Sorry, I should have mentioned it.

 

[Calver]

echo $this->row['firstname']; // Samuel

 

My headache's starting to diminish already! It didn't work until I did this...

 

echo $this->row[0]['firstname']; // Samuel

Brilliant, thank you very much for your help