PHP Array in a function

[LinusIT]

Hi

I'm trying to create a function that returns an array of data from a MySQL database but am having some trouble, I.E it isn't working.

I can get the array to work outside of the function but once I put the code into a function, it stops working.

Working array:

$sqlx = "SELECT vehicle_id FROM vehicles WHERE vehicle_diary=1";
$resultx = mysql_query($sqlx);
while ($rowx = mysql_fetch_row($resultx))
{
$result_array[] = $rowx[0];
}
print_r($result_array);

This returns - Array ( [0] => 1 [1] => 3 )

Not working function:

function diary_vehicle_select() {
$sqlx = "SELECT vehicle_id FROM vehicles WHERE vehicle_diary=1";
$resultx = mysql_query($sqlx);
$result_array = array();
while ($rowx = mysql_fetch_row($resultx))
{
$result_array[] = $rowx[0];
}
return $result_array;
}

This returns - Array

I have no doubt this is obvious to someone pretty much straight away. I just can't solve it myself. Thanks

[jadebox]

I don't see anything wrong in the function.

Can you post the code you used to call the function and display the result?

Is it possible that you accidently used "print($result_array)" instead of "print_r($result_array)" when checking the return from the function?

-- Roger

[Habtom]

What exactly returns "Array". If you do the following, what result do you get?

$newArr = diary_vehicle_select();
print_r($newArr);

[LinusIT]

I was using echo diary_vehicle_select(); which gave me the result Array.

If I use:

$newArr = diary_vehicle_select();
print_r($newArr);

Then this returns the array correctly, thank you.

[ericlewis107]

array_values($arr) function accepts a PHP array and returns a new array containing only its values (not its keys). Its counterpart is the array_keys() function. Use this function to retrieve all the values from an associative array.

Code:
$data = array("hero" => "Holmes", "villain" => "Moriarty");
print_r(array_values($data));
?>

Output:
Array
(
[0] => Holmes
[1] => Moriarty
)