Public feed
#604081
$news_query = "SELECT `news_title` AS `title` FROM `vds_news` WHERE `news_id`=:id LIMIT 1";
$port_query = "SELECT `port_title` AS `title` FROM `vds_portfolio` WHERE `port_id`=:id LIMIT 1";
$news_prep = $database->prepare($news_query);
$port_prep = $database->prepare($port_query);
$type_array = array(1 => 'News', 2 => 'Portfolio');
foreach($database->query($index_list_query) as $index_list)
{
if($index_list['index_type'] == 1) {
$news_prep->execute(array('id' => $index_list['type_id']));
$index_title = $news_prep->fetch();
} elseif($index_list['index_type'] == 2) {
$port_prep->execute(array('id' => $index_list['type_id']));
$index_title = $port_prep->fetch();
}
var_dump($index_title);
}