href statement

minds_gifts

hello everybody,
i displaying topicnames from the table topics.when i click on each topic name, it has to me a different file.for example,

topicname 1 will show file1.php
topicname 2 will show file2.php

Could somebody pls tell me how to modify my href st???

Thanks in advance

<?php
//Database connection
?>

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

<?
	$select_query = "SELECT TOPIC_NAME FROM topic";
	$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;

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

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

jpmoriarty

echo "<a href=\"".$row['TOPIC_NAME']."\">".$row['TOPIC_NAME']."</a>";

should do it.

Mordecai

Try using split() to split it at the space, then use the array[1] to get the right half of it. With that, you can make the link go to the numbers in the variable, not the entire thing.

jpmoriarty

ah yes sorry misread that one.

If your TOPIC_NAME values are just numbers, then you can do this:

echo "<a href=\"file".$row['TOPIC_NAME'].".php\">".$row['TOPIC_NAME']."</a>";

but if you need to extract the number or whatever then do as my good friend above suggests.