Retruning an array from a row

[erick_w]

Hello All,

How can I return and print an array from a user defined function from a database from a row like this, just one row, but it contains more than 1 column:
+--------+--------+
| Field1 | Field2 |
+--------+--------+
| Data1 | Data2 |
+--------+--------+

I want the output will be:
Data1
Data2

I have tried this:

funtion get_dbfield_data(){

$conn=dbconn(); // mysql connection function
$result=mysql_query("SELECT Field1,Field2 FROM table_name WHERE Condition);
$fields_data=array();

while($row=mysql_fetch_row($result)){
$fields_data[]=$row[0];
}

return $fields_data;
}
// End function

//... Now the main program

$data=get_dbfield_data();
$i=0;
foreach($data as $k){
echo "$k<br>";
$i++;
}

But the output only: Data1

🙁 and if I count(get_dbfield_data()) it returns 1. Can anybody help me? Thank you for your generous help...

--
Best regards,
Erick Wellem

[Jeepsta]

What about mysql_fetch_array()?

[erick_w]

The output is still: Data1

I want : Data1, Data2.

Thanks for replying 🙂

[erick_w]

Thanks, I've modified my code, and the solution is very simple 🙂

function get_dbfield_data(){

$conn=dbconn(); // mysql connection function
$result=mysql_query("SELECT Field1,Field2 FROM table_name WHERE Condition);
$row=mysql_fetch_array($result);

return $row;

}
// End function

//... Now the main program

$data=get_dbfield_data();

echo "Data Field : ".$data[0].", ".$data[1]."";
}

The Output:

Data Field : Data1, Data2

Thanks for inspiring reply Jeepsta... 🙂