Re: Query result to an array
| From: | OrangeHairedBoy | Date: | Thu, 12 Sep 2002 06:05:21 +0000 |
| Subject: | Re: Query result to an array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116090@lists.php.net to get a copy of this message | ||
Here's a function I wrote...feel free to use it. It will convert anything
into a 2D array.
Sample Table:
ID Name
1 Bob
2 Joe
3 Eric
4 Cody
$query="select * from sampletable";
$result=mysql_query($query);
$wholetable=ResultToArray($result,"ID");
foreach ($wholetable as $key=>$value)
{
print "$key. $value[Name]";
}
function ResultToArray ( $result , $key )
{
while ( $row = mysql_fetch_object ( $result ) )
{
foreach ( $row as $column => $data )
{
$thiskey=$row->$key;
$table[$thiskey][$column] = $data;
}
}
}
I hope this makes sense!!
Lewis
"Christian Ista" <christian.ista@teledisnet.be> wrote in message
news:200209120556.g8C5u1o02809@texas.pop3now.com...
> > array(
> > array( $temp[0], $temp[1] ),
> > array( $temp[1], $temp[2] )
> > )
>
> I thinks it's not the right way.
>
> I have a query, this query can return 1,5,20, 200, ... rows, each row has
> 5 fields (or more or less).
>
> I'd like a 2 dimensions array, one line by row and each cell is a field
> content of the query.
>
> I program in a lot of language C/C++, Java, Delphi, C++Builder,
> ColdFusion, C# and I don't undersand why the PHP syntax for this kind of
> think is so complex and not clear.
>
> Bye
>