Query returning array

[Karl Groves]

I'm missing something very obvious, but it is getting late and I've
stared at it too long.

TIA for responses
I am writing a basic function (listed at the bottom of this post) that
returns data from a query into an array.

The intent is that the following code:
$foo = dbSelectData("S ELECT foo, bar FROM table", $link);
would return an array with the keys: 'foo' and 'bar'.

But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}
I'm wondering where I went wrong in writing the function below.
function dbSelectData($q uery, $connection, $rtype=MYSQL_AS SOC){

$result = mysql_query($qu ery, $connection);
if(!$result){
dbThrowError("E rror in function dbSelectData. Query Was <em>
$query</em>.");
return FALSE;
}
else{
$numrows = mysql_num_rows( $result);

if($numrows == 0){
return FALSE;
}
else{
while($rows = mysql_fetch_arr ay($result, $rtype)){
$output[] = $rows;
}
mysql_free_resu lt($result);
return $output;
}
}
}
Thanks in advance.

--
Karl Groves

[Hendri Kurniawan]

Karl Groves wrote:

I'm missing something very obvious, but it is getting late and I've
stared at it too long.

TIA for responses
I am writing a basic function (listed at the bottom of this post) that
returns data from a query into an array.

The intent is that the following code:
$foo = dbSelectData("S ELECT foo, bar FROM table", $link);
would return an array with the keys: 'foo' and 'bar'.

But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}
I'm wondering where I went wrong in writing the function below.
function dbSelectData($q uery, $connection, $rtype=MYSQL_AS SOC){

$result = mysql_query($qu ery, $connection);
if(!$result){
dbThrowError("E rror in function dbSelectData. Query Was <em>
$query</em>.");
return FALSE;
}
else{
$numrows = mysql_num_rows( $result);

if($numrows == 0){
return FALSE;
}
else{
while($rows = mysql_fetch_arr ay($result, $rtype)){
$output[] = $rows;
}
mysql_free_resu lt($result);
return $output;
}
}
}
Thanks in advance.

That's weird, your code seems to be working on my box.
The only thing that i can think of right now that would return that
result is when you return $rows instead of $output.... or when you
assign your $rows to $output, you forgot the bracket (ie. $output[] =
$rows) .... but that is not the case with you posted code

Hendri Kurniawan

Hendri Kurniawan

[Steve]

"Karl Groves" <ka**@NOSPAMkar lcore.comwrote in message
news:Xn******** *************** ******@199.45.4 9.11...
| I'm missing something very obvious, but it is getting late and I've
| stared at it too long.

it is obvious to me only because i have programmed it already...here' s a
static method of my db class:

public static function execute($sql, $decode = false, $returnNewId =
false)
{
self::$lastStat ement = $sql;
$array = array();
$key = 0;
if (!($records = mysql_query($sq l))){ return false; }
$fieldCount = @mysql_num_fiel ds($records);
while ($row = @mysql_fetch_ar ray($records, MYSQL_NUM))
{
for ($i = 0; $i < $fieldCount; $i++)
{
$value = $row[$i];
if ($decode){ $value = self::decode($v alue); }
$array[$key][strtoupper(@mys ql_field_name($ records, $i))] = $value;
}
$key++;
}
if ($returnNewId)
{
$array = array();
$array[0]['ID'] = mysql_insert_id ();
}
@mysql_free_res ult($records);
return $array;
}

notice, and here's what your code is missing, the use of $key. that way you
create a multi-dimentional array of fields AT $key rather than what you're
getting now. here's example of useage:

$sql = "
SELECT Foo ,
Bar
FROM raspberries
";
$records = db::execute($sq l);
foreach ($records as $record)
{
echo '<pre>Foo == ' . $record['FOO'] . '</pre>';
echo '<pre>Bar == ' . $record['BAR'] . '</pre>';
}

hth,

me

[Steve]

| it is obvious to me only because i have programmed it already...here' s a
| static method of my db class:

oops...not so obvious. i mis-read how you were setting $output. it looks
like it should work fine.

are you expecting the query to return only a single row (by the nature of
the query), yet are confused as to why you are still getting an array? your
function always returns an array regardless of row count. you could just use
the $numrows and if one, return the single row...all others would still be
arrays of label/value pairs as it should be.

i don't know...it's late. :)

[Toby A Inkster]

Karl Groves wrote:

But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}

Umm... that isn't a multidimensiona l array. Translation follows:

array(2) { // Start of array with 2 elements
["foo"]= // Element with key "foo" is ...
string(5) "Stuff" // ... a 5 character string "Stuff"
["bar"]= // Element with key "bar" is ...
string(10) "More Stuff" // ... a 10 character string "More Stuff"
} // End of array.

A multidimensiona l array would look more like this:

array(1) {
[0]=>
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}
}

--
Toby A Inkster BSc (Hons) ARCS
http://tobyinkster.co.uk/
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!

[Hendri Kurniawan]

Toby A Inkster wrote:

Karl Groves wrote:

>But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}

Umm... that isn't a multidimensiona l array. Translation follows:

He was saying... that he expected multi-dimensional array, but get
something else instead.

Hendri Kurniawan

[Toby A Inkster]

Hendri Kurniawan wrote:

He was saying... that he expected multi-dimensional array, but get
something else instead.

He may have *meant* that, but it's certainly not what he *said*:

| The intent is that the following code: [...]
| would return an array with the keys: 'foo' and 'bar'.
|
| But what I get is instead a multidimensiona l array.

--
Toby A Inkster BSc (Hons) ARCS
http://tobyinkster.co.uk/
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!

[Karl Groves]

Toby A Inkster <us**********@t obyinkster.co.u kwrote in news:nfdmf4-
hc*****@ophelia .g5n.co.uk:

Karl Groves wrote:

>But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}

Umm... that isn't a multidimensiona l array. Translation follows:

array(2) { // Start of array with 2 elements
["foo"]= // Element with key "foo" is ...
string(5) "Stuff" // ... a 5 character string "Stuff"
["bar"]= // Element with key "bar" is ...
string(10) "More Stuff" // ... a 10 character string "More Stuff"
} // End of array.

A multidimensiona l array would look more like this:

array(1) {
[0]=>
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}
}

Very very sorry that my original post is unclear.

Yes, I am getting a multidimensiona l array. My var_dump looks exactly
like your second example. (and I wish it looked like the first, lol)

--
Karl Groves

[Jerry Stuckle]

Karl Groves wrote:

I'm missing something very obvious, but it is getting late and I've
stared at it too long.

TIA for responses
I am writing a basic function (listed at the bottom of this post) that
returns data from a query into an array.

The intent is that the following code:
$foo = dbSelectData("S ELECT foo, bar FROM table", $link);
would return an array with the keys: 'foo' and 'bar'.

But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}
I'm wondering where I went wrong in writing the function below.
function dbSelectData($q uery, $connection, $rtype=MYSQL_AS SOC){

$result = mysql_query($qu ery, $connection);
if(!$result){
dbThrowError("E rror in function dbSelectData. Query Was <em>
$query</em>.");
return FALSE;
}
else{
$numrows = mysql_num_rows( $result);

if($numrows == 0){
return FALSE;
}
else{
while($rows = mysql_fetch_arr ay($result, $rtype)){
$output[] = $rows;
}
mysql_free_resu lt($result);
return $output;
}
}
}
Thanks in advance.

Hi, Karl,

I'm confused. This should work.

while($rows = mysql_fetch_arr ay($result, $rtype)){

$rows will be a single dimensional array with indexes ['foo'] and ['bar'].

$output[] = $rows;
}
And $output will be an array of the above array with indexes zero to
(number_of_rows _returned - 1).

Are you sure this is the exact code? If so, can you show us where you
call it and dump the results? Maybe the problem is back there.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Karl Groves]

Jerry Stuckle <js*******@attg lobal.netwrote in
news:Vp******** *************** *******@comcast .com:

Karl Groves wrote:

>I'm missing something very obvious, but it is getting late and I've
stared at it too long.

TIA for responses
I am writing a basic function (listed at the bottom of this post)
that returns data from a query into an array.

The intent is that the following code:
$foo = dbSelectData("S ELECT foo, bar FROM table", $link);
would return an array with the keys: 'foo' and 'bar'.

But what I get is instead a multidimensiona l array.
Doing a var_dump on $foo turns out to be
array(2) {
["foo"]=>
string(5) "Stuff"
["bar"]=>
string(10) "More Stuff"
}
I'm wondering where I went wrong in writing the function below.
function dbSelectData($q uery, $connection, $rtype=MYSQL_AS SOC){

$result = mysql_query($qu ery, $connection);
if(!$result){
dbThrowError("E rror in function dbSelectData. Query Was
<em>
$query</em>.");
return FALSE;
}
else{
$numrows = mysql_num_rows( $result);

if($numrows == 0){
return FALSE;
}
else{
while($rows = mysql_fetch_arr ay($result, $rtype)){
$output[] = $rows;
}
mysql_free_resu lt($result);
return $output;
}
}
}
Thanks in advance.

Hi, Karl,

I'm confused. This should work.

while($rows = mysql_fetch_arr ay($result, $rtype)){

$rows will be a single dimensional array with indexes ['foo'] and
['bar'].

$output[] = $rows;
}
And $output will be an array of the above array with indexes zero to
(number_of_rows _returned - 1).

Are you sure this is the exact code? If so, can you show us where you
call it and dump the results? Maybe the problem is back there.

I apologize to everyone for the confusion in my original post.
My var_dump example was wrong.
I'm getting a multidimensiona l array and want a single dimension.

I recognize that my use of $output[] = $rows; seems to be the reason why
I get the multidimensiona l array. I guess my real issue is figuring out
how to get ALL returned rows of the single dimensional array. Everything
else I've tried gives me one row.
--
Karl Groves