Populate an array with DB results

[backtobasics]

I'm using the 'Auto-Complete' feature from the Yahoo! UI Library, which is working fine.

The array used to return data to the drop-down of 'auto-completed' results is like so:

return array(
    'a' => array(
        "apple"
    ),
    
    'b' =>(
        "banana"
    ),
        
    'o' =>(
        "orange"
    )
); 

However, I need this to be populated with results pulled in from a database...

Any idea how I can do this??

Cheeeeeers

[FSan]

mysql_fetch_assoc ...?

[backtobasics]

Didn't work..cheers, though.

Any other suggestions?

[byron3@earthlink]

I'm using the 'Auto-Complete' feature from the Yahoo! UI Library, which is working fine.
However, I need this to be populated with results pulled in from a database...
Any idea how I can do this??

Cheeeeeers

When you say populated with results pulled in from a database.... Are you wanting to combine 2 arrays? Could you provide an example of the returned database data and the final format of combined data you are wanting?

[backtobasics]

Could you provide an example of the returned database data and the final format of combined data you are wanting?

Well, the array I posted orginally, is what I need...

But I need, for example, 'a', 'b' and 'o' to be filled with data pulled from a database instead of hard-coded.

So, if in the database there was a field which contained 'pear', then it would be added into the array like so:

'p' => array(
        "pear",
        ) 

Do you follow?

[byron3@earthlink]

function KeyExist( $MyArray, $compare ) { // Does this key exist in this array?
    foreach ( $MyArray as $k => $data ) {
        if ( $k == $compare ) { return TRUE; }
    }
    Return FALSE;
}

/* Open database and run mysql query to generate result set */
$list = array(); //Create master array

while ( $row = mysql_fetch_assoc( $results ); {
    $value = $row['Data_For_Array'] // Value to add to sub array in master array
    $key = substr( $value, 0, 1); // Get first letter to use as key

    if ( KeyExist( $list, $key ) { // Does this key already exist in master array?
        $list[$key] = $value; // Yes so add value to sub array
    } else {
        $list[$key] = array(); // No so create sub array
        $list[$key] = value; // Add value to sub array 
    }
} 

Does this fit the bill?

[backtobasics]

Nope, doesn't do the job I'm afraid

[byron3@earthlink]

What does the output look like?

[backtobasics]

It works fine, it's just not what I need.

Thanks for your help, though..

[byron3@earthlink]

function KeyExist( $MyArray, $compare ) { // Does this key exist in this array?
    foreach ( $MyArray as $k => $data ) {
        if ( $k == $compare ) { return TRUE; }
    }
    Return FALSE;
}

/* Open database and run mysql query to generate result set */
$list = array(); //Create master array

while ( $row = mysql_fetch_assoc( $results )) {
    $value = $row['Data_For_Array']; // Value to add to sub array in master array
    $key = substr( $value, 0, 1); // Get first letter to use as key

    if ( KeyExist( $list, $key )) { // Does this key already exist in master array?
        $idx = count( $list[$key] );
        $list[$key][$idx] = $value; // Yes so add value to sub array
    } else {
        $list[$key] = array(); // No so create sub array
        $list[$key][0] = value; // Add value to sub array 
    }
} 

Try it one more time, The above snippet takes this array:

array( "apple",
"bannana",
"pear",
"orange",
"opal",
"olive");

and produces the following output:

Array ( [a] => Array ( [0] => apple ) [b] => Array ( [0] => bannana ) [p] => Array ( [0] => pear ) [o] => Array ( [0] => orange [1] => opal [2] => olive ) )

[backtobasics]

That works fine, but I still can't get it to pass through the data that I need!

When I 'print_r' that array and the original array, they're both looking the same...not sure what's happening/I'm missing!

[byron3@earthlink]

Post your code where you are passing the data array to your interface.