Trying to get data from Array

[Dave M]

Hi all,

 

I'm trying to put a recordset into an array and retrieve data from the array.

 

The code I have used to create the array is:

 

$newarray = array(); 
$query = 'SELECT filename FROM phototable' . $where; 
$rs = mysql_query($query, $con) or die(mysql_error());

while($row=mysql_fetch_assoc($rs)) {array_push($newarray, $row);} 

 

When I use

<?php var_dump($newarray); ?>

this is returned:

 

array(4) { [0]=> array(1) { ["filename"]=> string(2) "29" } [1]=> array(1) { ["filename"]=> string( "13683-24" } [2]=> array(1) { ["filename"]=> string(2) "34" } [3]=> array(1) { ["filename"]=> string(2) "33" } }

 

I was hoping to use $newarray[0] to return the first value, $newarray[1] to return the second value etc, but when I type this i just get "array" as the result.....

 

How can I create an array that just returns values that I can access in the above method?

 

I am using MySQL 5.1.37

My table is called phototable the column I want to create the array from is called filename

 

Many thanks in advance,

 

Dave.

 

 

[sasa]

while($row=mysql_fetch_assoc($rs)) {array_push($newarray, $row['filename']);} 

[Dave M]

Hi,

 

Thanks for getting back to me so quickly.

 

If I type

<?php $newarray[0]; ?>

nothing is returned. I would expect 29 to be returned. Given that that is the first value in the array.

 

Thanks again,

 

Dave.

[Dave M]

Yes yes, OK I know what I have done!

 

try echo....

 

 

Again, thanks a million,

 

Dave.