To print a field name

minds_gifts

Hello, the following piece of code displays some article names and when you click on them, they display the content of each article.

Now, i'm trying to print the topic name on the top of the article content. how and where should i add my echo statement??well, can i also add a back ground to the topic name??how

Thanks in advance


<?php
	include "../dbconnection.ini";
?>

<html>
<head>
<title></title>
</head>
<body>

<?
	$select_query = "SELECT ARTICLE_NAME, ARTICLE_CONTENT, TOPIC_NAME FROM article left join topic using (TOPIC_ID) where SUBTOPIC_ID = 2";
	$result = mysql_query($select_query);
	$numrows = mysql_num_rows($result);
	while($row = mysql_fetch_array($result))
    {
?>
<table border="1" cellpadding="2" cellspacing="2" width="275">

  <tr>
      <td width="280">&nbsp;

<?
//Prints the article name and links to the content

echo "<a href='".$row[ARTICLE_CONTENT]."'>  ".$row[ARTICLE_NAME]."</a>";
?>

  </td>
  </tr>
</table>
<?
    }
?>
</body>
</html>

pyro

It's not clear what you are trying to do. Would you please clarify?

minds_gifts

when you click on a topic name, you get the sub-topic name along with the article names and when you click on a article name, article content is shown.

Now, on the top of the article content, i want to show this topic name.

In my sql st, i've written in order to get the topic name.

In my echo st, I'm printing the article name and it is referring to article content.

How can i modify this statement in order to make sure when the article content is shown, above that my topic name is also shown.

Thanks in advance

EviL_CodE

<?
//Prints topic name with a css induced background
echo "<span style=\"background-color:#00FFFF;\">".$row[TOPIC_NAME]."</span><br />\n";

//Prints the article name and links to the content
echo "<a href='".$row[ARTICLE_CONTENT]."'>  ".$row[ARTICLE_NAME]."</a>";
?>

I think that's what you're looking for. If not, post back and we'll sort you out.