Posted by Karl Groves on 04/20/07 03:45

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("SELECT foo, bar FROM table", $link);
would return an array with the keys: 'foo' and 'bar'.

But what I get is instead a multidimensional 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($query, $connection, $rtype=MYSQL_ASSOC){

$result = mysql_query($query, $connection);
if(!$result){
dbThrowError("Error 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_array($result, $rtype)){
$output[] = $rows;
}
mysql_free_result($result);
return $output;
}
}
}


Thanks in advance.

--
Karl Groves

• Next in forum: array_walk - userdata as array by ref
• Prev in forum: Re: Want to store what keyword was used if ref from Google
• Thread view: Query returning array

[Reply to this message]