Retruning an array from a row

From: Date: Wed, 30 Oct 2002 11:44:25 +0000
Subject: Retruning an array from a row
Groups: php.db 
Request: Send a blank email to php-db+get-22817@lists.php.net to get a copy of this message
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 columns: +--------+--------+ | 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++; } The output : 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

« previous php.db (#22817) next »