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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
