Re: [PHP] Query result to an array
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 12, 2002 01:55, Christian Ista wrote: > > $result = mysql_query(...); > > while( $t = mysql_fetch_row($result) ){ > > $array[] = $t; > > } > > No. I need a 2 dimensions arrays, each line of this array, is the result > of one row of the query and each cell of this row is a field from the > select. Did you test the code? :) > Example, the query return 2 row and 3 fields for each row : > "Christian", "Ista", "Belgium" > "zak", "PhpNet", "Dontknowfrom" > > resulf of SELECT NAME, LASTNAME, COUNTRY FROM MyTable; The code snippet above combined with the above query would create an array of this structure: $array[0][0] = 'Christian'; $array[0][1] = 'Ista'; $array[0][2] = 'Belgium'; $array[1][0] = 'zak'; $array[1][1] = 'PhpNet'; $array[1][2] = 'Canada'; > I'd like to put that in an array and later because I use a session array. > > I'd like via a for loop access these data by > echo(MyArray[1][1]); result is "PhpNet" > echo(MyArray[0][2]); result is "Belgium" > echo(MyArray[1][0]); result is "zak" > > Is it clearer now ? Cheers! - --zak -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9gD/1b6QONwsK8bIRAmm7AJ41PUo2zVmFwN/vfvTr4j6Fze/NdwCbBPZm bWnEPyBj+bKQsnQ2bg9HZ7E= =q8vy -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query result to an array
> > $result = mysql_query(...); > while( $t = mysql_fetch_row($result) ){ > $array[] = $t; > } > > No. I need a 2 dimensions arrays, each line of this array, is the result > of one row of the query and each cell of this row is a field from the > select. > > Example, the query return 2 row and 3 fields for each row : > "Christian", "Ista", "Belgium" > "zak", "PhpNet", "Dontknowfrom" > > resulf of SELECT NAME, LASTNAME, COUNTRY FROM MyTable; > > I'd like to put that in an array and later because I use a session array. > > I'd like via a for loop access these data by > echo(MyArray[1][1]); result is "PhpNet" > echo(MyArray[0][2]); result is "Belgium" > echo(MyArray[1][0]); result is "zak" > > Is it clearer now ? > > Thanks, > > Christian > That's exactly what this will do. mysql_fetch_row() returns an array. Appending that to another array and you get back an array of arrays (which is the same as a 2D array) Try it and see... Martin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query result to an array
> $result = mysql_query(...); > while( $t = mysql_fetch_row($result) ){ > $array[] = $t; > } No. I need a 2 dimensions arrays, each line of this array, is the result of one row of the query and each cell of this row is a field from the select. Example, the query return 2 row and 3 fields for each row : "Christian", "Ista", "Belgium" "zak", "PhpNet", "Dontknowfrom" resulf of SELECT NAME, LASTNAME, COUNTRY FROM MyTable; I'd like to put that in an array and later because I use a session array. I'd like via a for loop access these data by echo(MyArray[1][1]); result is "PhpNet" echo(MyArray[0][2]); result is "Belgium" echo(MyArray[1][0]); result is "zak" Is it clearer now ? Thanks, Christian -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query result to an array
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 12, 2002 00:56, Christian Ista wrote: > > 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. Good Lord! I thought that you wanted to transform an of array query results into a multi-dimensional array. Briefly, you want to do this: $result = mysql_query(...); while( $t = mysql_fetch_row($result) ){ $array[] = $t; } Just read the MySQL section in the PHP manual for more details. Cheers! - --zak -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9gDCIb6QONwsK8bIRAitjAJ0bUVpwvcdbrIayNQFtbfPqtHJSkwCdGmrq OIkNSi0vING+U/+/GgYf/58= =d63f -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query result to an array
Here's a function I wrote...feel free to use it. It will convert anything into a 2D array. Sample Table: ID Name 1Bob 2Joe 3Eric 4Cody $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
RE: [PHP] Query result to an array
I'm not totally familiar with mySql, but if I remember correctly, you can get each row (one at a time) back as an (1D) array. All you need to do is append that array onto the end of your dataset array and, bob's your uncle, you have a 2D array full with your dataset HTH Martin -Original Message- From: Christian Ista [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 4:56 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Query result to an array > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query result to an array
> 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
Re: [PHP] Query result to an array
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 11, 2002 15:21, Christian Ista wrote: > > while( $temp = mysql_fetch_row($mysql_result_handle) ) { > > $array[] = array( > > 'key0' => array( > > 'keya' => $temp[0], > > 'keyb' => $temp[1] > > ), > > 'key1' => array( > > 'keya' => $temp[2], > > 'keyb' => $temp[3] > > ) > > ); > > } > > I corrected this error myself but that's not work. > > Why that twice ? (only the key change) > > 'key0' => array( > 'keya' => $temp[0], > 'keyb' => $temp[1] > ), > > when I do echo($array[0][1]) I receive array unknown. Ok - if you want a numeric array, then do something like this: array( array( $temp[0], $temp[1] ), array( $temp[1], $temp[2] ) ) --zak -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9f7p3b6QONwsK8bIRAhEpAJ4vU+f/AovqfUkHvdnBf6le47N9AACfdK7K L6Ub877d4ZUwbxSXF6gl9qY= =Vnxt -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query result to an array
> while( $temp = mysql_fetch_row($mysql_result_handle) ) { > $array[] = array( > 'key0' => array( > 'keya' => $temp[0], > 'keyb' => $temp[1] > ), > 'key1' => array( > 'keya' => $temp[2], > 'keyb' => $temp[3] > ) > ); > } I corrected this error myself but that's not work. Why that twice ? (only the key change) 'key0' => array( 'keya' => $temp[0], 'keyb' => $temp[1] ), when I do echo($array[0][1]) I receive array unknown. Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query result to an array
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 11, 2002 15:05, Christian Ista wrote: > > while( $temp = mysql_fetch_row($mysql_result_handle) ) { > > $array[] = array( > > 'key0' = array( > > 'keya' => $temp[0], > > 'keyb' => $temp[1], > > ), > > 'key1' = array( > > 'keya' => $temp[2], > > 'keyb' => $temp[3], > > ) > > ); > > } > > Hello, > > Thanks for your help. But that's not work at all. Dear Christian, I assume that you encountered some syntax errors in the code? (or was there another problem?) Anyhow, here is the corrected version while( $temp = mysql_fetch_row($mysql_result_handle) ) { $array[] = array( 'key0' => array( 'keya' => $temp[0], 'keyb' => $temp[1] ), 'key1' => array( 'keya' => $temp[2], 'keyb' => $temp[3] ) ); } - --zak -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9f7K3b6QONwsK8bIRAiATAJ9TPv/28hZiF136TePF5SXTgDinUACgkg6w BJVDvRVsVzqplDLOD/u5u4E= =NbgV -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Query result to an array
> while( $temp = mysql_fetch_row($mysql_result_handle) ) { > $array[] = array( > 'key0' = array( > 'keya' => $temp[0], > 'keyb' => $temp[1], > ), > 'key1' = array( > 'keya' => $temp[2], > 'keyb' => $temp[3], > ) > ); > } Hello, Thanks for your help. But that's not work at all. bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Query result to an array
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 11, 2002 14:12, Christian Ista wrote: > Hello, > > A query return x rows, by rows there are 4 fields. I'd like to put the > result in an array, a 2 dimensions array. Could you tell me how to do > that ? Something like this may work for you: # Connect to db, make query, etc. while( $temp = mysql_fetch_row($mysql_result_handle) ) { $array[] = array( 'key0' = array( 'keya' => $temp[0], 'keyb' => $temp[1], ), 'key1' = array( 'keya' => $temp[2], 'keyb' => $temp[3], ) ); } Good luck! - --zak -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9f6tAb6QONwsK8bIRAvjKAJwKN0yvbGaztQzZOKYiy22FMqQ5EgCeP3AH 4sGpVTTX6gUJp8fZJ8xXEfQ= =eaeg -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Query result to an array
Hello, A query return x rows, by rows there are 4 fields. I'd like to put the result in an array, a 2 dimensions array. Could you tell me how to do that ? Bye -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php