The code below generates the following

PHP Code:

$sectlist = "";
$sql = "SELECT sect_name, sect_image, art_title, art_image1 FROM sections, artSections, articles WHERE art_approved = 1 AND art_archived = 0 AND sect_id = as_section AND as_article = art_id AND sect_id != 2";
$result1 = mysql_query($sql);
$num_rows = mysql_num_rows($result1);
$combinedResults = array();

while($result = mysql_fetch_array($result1)) {  
    $combinedResults[$result['sect_name']][] = array(
      'title' => $result['art_title'],
      'img' => $result['art_image1'],
    );
}

$sectlist .= "<ul>";
// now loop through the combined results
foreach(array_keys($combinedResults) as $groupKey) {
    $sectlist .= "<li>".$groupKey. PHP_EOL; //Need image here
    $sectlist .= "<ul>". PHP_EOL;
    foreach($combinedResults[$groupKey] as $item) {
        $sectlist .= "<li>".$item['title']." <img src='images/uploaded/" . $item['img'] . "' width='20px'></li>". PHP_EOL;
    }
    $sectlist .= "</ul>". PHP_EOL;
    $sectlist .= "</li>". PHP_EOL;
}
$sectlist.= "</ul>";  
//End section list 


I'm having a problem getting an image next to the main bullet points. Could someone point me in the right direction.

Cheers

Wayne.

Can't you just add the image before the nested list?

PHP Code:

$sectlist .= "<li>" . $groupKey . '<img src="someimage" />' . PHP_EOL; 


If the problem you are having is with styling the list and not actually updating the PHP code you might want to post the output of that code in the CSS forum.

or were you hoping to turn the bullet into the image?

NullPointer, The image for the section is pulled from the database. I can put the image next to the section name but it brings in the same image (Dining Furniture)

Set the image here

PHP Code:

while($result = mysql_fetch_array($result1)) {  
    $combinedResults[$result['sect_name']][] = array(
      'title' => $result['art_title'],
      'img' => $result['art_image1'],
    );
    $img = $result['sect_image']; //Set image here
    
} 


Used the image here

PHP Code:

$sectlist .= "<li>".$groupKey." <img src='images/uploaded/$img' width='30px'></li>". PHP_EOL; 


Calling print_r on $combinedResults might shed some light on where the image you are looking for is stored.

I've called print_r $combinedResults and the section images are not showing

Array
(
    [Chairs, Sofas & Footstools] => Array
        (
            [0] => Array
                (
                    [title] => Seville High Back Chair
                    [img] => 2010_09_28_11_53_46_seville-hb-chair_sm.jpg
                )

            [1] => Array
                (
                    [title] => Seville Standard Back Chair
                    [img] => 2010_09_28_11_54_08_seville-sb-chair_sm.jpg
                )

            [2] => Array
                (
                    [title] => Seville Low Back Chair
                    [img] => 2010_09_28_11_54_27_seville-lb-chair_sm.jpg
                )

            [3] => Array
                (
                    [title] => Seville Standard Back Sofa
                    [img] => 2010_09_28_11_54_41_seville-sb-sofa_sm.jpg
                )

            [4] => Array
                (
                    [title] => Ontario Wing Chair
                    [img] => 2010_09_28_13_47_56_ontario-wing-chair-sm.jpg
                )

            [5] => Array
                (
                    [title] => Ontario High Back Chair
                    [img] => 2010_09_28_13_48_13_ontario-hb-chair-sm.jpg
                )

        )

    [Dining Furniture] => Array
        (
            [0] => Array
                (
                    [title] => Barcelona Dining Set
                    [img] => 2010_09_28_14_02_42_barcelona-dining-set_sm.jpg
                )

            [1] => Array
                (
                    [title] => Turned Leg Table
                    [img] => 2010_09_28_14_03_57_turned-leg-table_sm.jpg
                )

            [2] => Array
                (
                    [title] => Buffalo Chair
                    [img] => 2010_09_28_14_04_27_buffalo-chair-sm.jpg
                )

        )

)

With the code as it is now this is what I get

I've taken a closer look at your code. Here is what I think you need to do:

PHP Code:

$img = array();
while($result = mysql_fetch_array($result1)) {  
    $combinedResults[$result['sect_name']][] = array(
      'title' => $result['art_title'],
      'img' => $result['art_image1'],
    );
    $img[] = $result['sect_image']; //Set image here
    
} 


Notice I made $img an array. This way you don't overwrite the previous section image when on this line:

PHP Code:

$img[] = $result['sect_image']; //Set image here 


All you should need to do is output it. array_shift just removes and then returns the first element in the array:

PHP Code:

$sectlist .= "<li>".$groupKey. '<img src="' . array_shift($img) . '" />' . PHP_EOL; //Need image here 


Cheers NullPointer,

I'll give it a go and let you know.

Thanks again

Wayne.