Re: Retruning an array from a row

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




----- Original Message -----
From: "Erick Wellem" <erick@biangnya.com>
To: <php-db@lists.php.net>
Sent: Wednesday, October 30, 2002 6:44 AM
Subject:  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...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux