Вывод данных из ячейки БД mysql

$query = mysqli_query($link, "SELECT CONTENT FROM PAGES WHERE PAGES.NAME = 'main'") or die(mysqli_error($link));
while($result = mysqli_fetch_assoc($query)){
  echo $result['CONTENT'];
}

$bd = mysqli_connect("localhost", "my_user", "my_password", "my_db");
$sql = mysqli_query($bd, "SELECT CONTENT FROM PAGES WHERE NAME = 'main'") or die(mysqli_error());
$row = mysqli_fetch_array($sql);
echo $row['CONTENT']; //здесь должна быть запись hello world если конечно у Вас одна строчна с NAME = 'main'

<?
include ('../db/db-config.php');
include ('../contents/header.php');
 
$result = mysql_query("SELECT text FROM pages WHERE Pages.id=1");
echo $result;
 
include ('../contents/footer.php');
?>

$result = mysql_query("SELECT text FROM pages WHERE Pages.id=1");
echo $result;

<?
include ('../db/db-config.php');
include ('../contents/header.php');
 
$result = mysql_query("SELECT text FROM Pages WHERE Pages.id='1'") or die("ERROR: ".mysql_error());
 
$row = mysqli_fetch_array($result);
echo $row['text'];
 
include ('../contents/footer.php');
?>