[SOLVED] seperating an array retireved from a database

[mindstorm]

hi there, i am struggeling with my array.

 

when i echo it i only recieve the word 'Array' on the screen

i have an example here

http://www.deakin.edu.au/~pr200808/prototype/news.php

 

 

 

This array has been retrieved from an qracle database and has three fields

 

N_ID

N_DATE

N_NEWS

 

so the array only has the there fields.

 

how do i go about seperating these three fields into seperate variables to that they can be displayed by them selves?

 

thanks.

[JasonLewis]

Try using print_r() instead of echo.

 

echo "<pre>", print_r($your_array), "</pre>";

 

To access the elements, you need to do it like so:

 

echo $your_array['N_DATE'];

[mindstorm]

thanks,

the first part worked brilliantly,

 

second part was not quite right,

it needed to be

echo $dbResult [0] ['N_ID']; 

 

but still thanks. would not have worked it out if it weren't for this help.

 

 

cheers

[Adam]

Never really worked with oracle before so can't say a great deal.. but if you show a little more code just sorta how you retrieve the array from the db, might be able to help you bit more..

 

Adam