query("SELECT content_id, content_url, thumbnail_url, is_active, is_offer FROM edu_contents ORDER BY content_id")->fetchAll(PDO::FETCH_ASSOC); foreach($rows as $r) { echo sprintf("%-20s | is_offer=%-2s | is_active=%-2s | url=%-40s | thumb=%s\n", $r['content_id'], $r['is_offer'], $r['is_active'], $r['content_url'], $r['thumbnail_url'] ); }