'.$title.''; $query = ' SELECT *, salemtsh_news.title as news_title, salemtsh_offices.title as author_title, salemtsh_users.id as author_id, salemtsh_news.id as news_id FROM salemtsh_news LEFT JOIN salemtsh_users ON salemtsh_news.author = salemtsh_users.id LEFT JOIN salemtsh_offices ON salemtsh_users.office = salemtsh_offices.id WHERE salemtsh_news.active = 1 ORDER BY date DESC LIMIT 10 '; $count=0; $result = mysqli_query($conn, $query); if (!$result) { die("Error in SQL query: " . mysqli_error($conn)); } while($row=mysqli_fetch_array($result)) { if(!empty($row['link'])){ echo '

'.$row['news_title'].'

'; }else{ echo '

'.$row['news_title'].'

'; } $contentWithLinks = preg_replace('/#(\w+)/', '#$1', $row['content']); echo '

'; if ($validated == 1) { echo ' '; } echo $row['date'].' - '.nl2br($contentWithLinks); require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/author.php'; echo '

'; } // playlist https://www.youtube.com/playlist?list=PLV0AT5mICBl5v5po7X6ITkNfHwRyr9Qc5 // colab link https://www.youtube.com/playlist?list=PLV0AT5mICBl5v5po7X6ITkNfHwRyr9Qc5&jct=L4TAdFNHLvRBUpt6wziyf1rJnYzjtw require_once $_SERVER['DOCUMENT_ROOT'] . '/includes/after.php'; ?>