Re: Retruning an array from a row
| From: | 1LT John W. Holmes | Date: | Wed, 30 Oct 2002 12:53:30 +0000 |
| Subject: | Re: Retruning an array from a row | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22819@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "Erick Wellem" <erick@biangnya.com>
To: <php-db@lists.php.net>
Sent: Wednesday, October 30, 2002 6:44 AM
Subject: [PHP-DB] Retruning an array from a row
> 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];
You're only returning the first column of each row. If you just want to
return the first row in the result, then do this:
$result = mysql_query(...)
$row = mysql_fetch_row($result)
return $row;
---John Holmes...