query($lat_news_query) as $row) {
$buzzynews_id = $row['buzzynews_id'];
$buzzynews_author_id = $row['buzzyuser_id'];
$buzzynews_title = $row['buzzynews_title'];
$buzzynews_timestamp = $row['buzzynews_timestamp'];
$formated_buzzynews_timestamp= date("d.m.Y", $buzzynews_timestamp);
if ($row['buzzynews_image']!=''){
$buzzynews_image=$row['buzzynews_image'];
$buzzynews_url = $row['buzzynews_url'];
if (substr($buzzynews_image, 0, 7) == 'http://' OR substr($buzzynews_image, 0, 8) == 'https://') {
$image_prefix='';
}
else {
$image_prefix=$link_prefix.'img/thumbnails/';
}
}
else{
$buzzynews_image='noimage.jpg';
}
$final_buzzynews_image=$image_prefix.$buzzynews_image;
$buzzynews_text = $row['buzzynews_text'];
$short_buzzynews_text = substr($buzzynews_text, 0, 100);
$latnews_author_query = "SELECT * FROM buzzyusers WHERE buzzyuser_id=$buzzynews_author_id";
if($buzzynews_author_id==0){
$buzzynews_author_username='Admin';
}
if($buzzynews_author_id!=0){
foreach ($connread->query($latnews_author_query) as $row) {
$buzzynews_author_username=$row['buzzyuser_username'];
}
}
?>