Arrays again

trooper

Hi Guys

Quick question

im pulling something from a db and putting it into an associateive array.

How do i actually access the key and value of the items in the array

here is my code
$SQL = "SELECT id, name FROM sections WHERE parent ='$this_section'";
$result = mysql_query($SQL);

$section_names = Array();
while($section_names[] = mysql_fetch_assoc($result))
{

}			
	return $section_names;

van__

$SQL = "SELECT id, name FROM sections WHERE parent ='$this_section'";
$result = mysql_query($SQL);

for ($i=0;$i<mysql_num_rows($result);$i++) {
$myArray[$i] = @mysql_fetch_array($result, MYSQL_ASSOC);
}

//and here's your entire set packed into an array.
print_r($myArray);

van__

oh, and for the key and value calling...

<?
foreach ($myArray as $key=>$val) {
echo $key ': ' . $val . '<br>\n';
}
?>

or by hand...
$myArray[$i]['columnName'];

trooper

Hmm not quite what i wanted.

I want to have an array that contains the section name and the id of the section (in a function). Then i can use that 2 dimensional array in other functions

The problem is that i can return either the name or the id from the function but not both?

Anyone got ideas?

trooper

That gives me
0 => Array<-this is 2 dimensional
1 => Array
2 => Array
3 => Array
4 => Array
5 => Array

which is not quite what i wanted. I want the id of the section and the name of section.

Any ideas?

van__

Gary Mailer wrote:

Hmm not quite what i wanted.

I want to have an array that contains the section name and the id of the section (in a function). Then i can use that 2 dimensional array in other functions

The problem is that i can return either the name or the id from the function but not both?

Anyone got ideas?

Well, that's not what you asked for 🙂
You wanted to know how to access the key and value items, not create a new array by keys.

Anyway...

So I don't have to repeat myself use what I gave you in the prior example because you need that. What MySQL returns is not an array, it's a resource that is called a result set, but an array an a resource are two different things. So we first must parse out all the rows from the resource into an array.

So now that we got that covered and we have a hash table for parsing...

<?
for ($i=0;$i<count(array_keys($myArray));$i++) {
$sectionArray[$myArray[$i]['section']] = $myArray[$i]['id'];
}
}

/ Your array should look like
[section]=>id /

// now put it to the GLOBAL scope..
$GLOBALS['sectionArray'] = $sectionArray;

// now create your function...

function myFuncName($vals) {
//in here you can call your array as follows...
print_r($GLOBALS['sectionArray']);
}

// and run it.
myFuncName('');

And that should do it.

trooper

Hey Van

I Hate to be a pain but this just ain't working for me -doh

trooper

Thanks Van for your help

I jusst was not 100% sure about how to loop through an array using the keys.

thanks again

Gary Mailer