Populate array from database -> Foreach loop

[Solved_]

I have a database table in wordpress, now I want to get all titles, content, order values out of the database and compile to a post and put them in an array. Nothing happens, no errors. If i change some code, I can get the first value, but not a repeated process, to fetch all data.

 

global $wpdb;

$sDB = $wpdb->get_results("SELECT my_title, my_content, my_order FROM my_table");
foreach ($sDB as $sDBOutput) {

  	$sATitle = $sDBOutput->my_title;	
$sAContent = $sDBOutput->my_content;
$sAOrder = $sDBOutput->my_order;

$sCompiled = '<div class="title">' . $sATitle . '</div><div class="content">' . $sAContent . '</div>';

$aPost = array();

$aPost[$sAOrder] = $sCompiled;
}

[ignace]

Try this:

 

global $wpdb;

$aPost = array();
$sDB = $wpdb->get_results("SELECT my_title, my_content, my_order FROM my_table");
foreach ($sDB as $sDBOutput) {

  	$sATitle = $sDBOutput->my_title;	
$sAContent = $sDBOutput->my_content;
$sAOrder = $sDBOutput->my_order;

$sCompiled = '<div class="title">' . $sATitle . '</div><div class="content">' . $sAContent . '</div>';


if (isset($aPost[$sAOrder])) {
            // debug line
            echo 'overwriting existing key ' . $sAOrder . ' original: ' . $aPost[$sAOrder] . ' new: ' . $sCompiled . '<br>';
        }
$aPost[$sAOrder] = $sCompiled;
}

[Solved_]

Thanks that worked, am i right, that the only change is $aPost = array(); to above (except the debug ofcourse)?

 

I was empting the array every time..

[ignace]

Correct.