Text not displaying

bravo14

Hello

I am trying to display some text but it is not displaying

the offending line is

echo $row["content"];

the page code is

<?php include('includes/connect.php'); ?>
<?php 
$sql=('SELECT * FROM `tbl_content` WHERE `page_id` = \'' . $_GET['page_id'] . '\' LIMIT 1');
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
echo('

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Project Renovations | '.$row['title'].'</title>');
?>
<link rel="stylesheet" href="css/template_css.css" type="text/css" />
<link rel="shortcut icon" href="images/favicon.ico" />
</head>
<body>
<div align="center">
<table align="center" width="600px" bordercolor="#000066" border="2px single" >
<tr><td><table>
<tr><td valign="top">
<div id="header">
<div id="nav">
<?php
include_once('includes/nav_menu.php');
?>
</div>
</div>
</td>
</tr>
<tr><td align="right">


</td>
<tr>
  <td><div id="content">
  <div>
  <div id="maintext">
<?php
echo $row["content"];
?>
  </div>
  <div id="randomgallery">

  <?php include "randomimage.php"; ?>
  </div>
  </div>
  </div></td>
</tr>
</table>
</tr></tr></table>
</div>
</body>
</html>

Where have I gone wrong?

Cheers

Mark

Weedpacket

Does the title contain the value of $row['title']?

bravo14

Yeah, the only one that is not picking anything up is the content section.

Kudose

You are probably overwriting $row in includes/nav_menu.php

Weedpacket

Or maybe the "content" field in tbl_content happens to be empty there. Or maybe tb_content doesn't have a "content" field (naming the columns you actually want instead of just shovelling out everything with "SELECT *" is good SQL).

But I'm willing to go with Kudose's hypothesis: $row is such a generic name that it risks being overwritten by some other thing that could be called $row equally generically.