A simple script driving me crazy

minds_gifts

hello phpgurus,
A simple script and Pretty straight forward one, but driving me nuts.

well, here what i'm trying to do....

1.Displaying the records from a mysql table.
2.when the user clicks on the record, a new page has to be displayed.

Whats the error i'm getting???

When i click on the record, the folder contents are opened rather than the file.

Here how my table looks like

Id PARENTTOPIC_NAME PARENTTOPIC_CONTENT

1 comedy humour.php
2 fiction science.php

Now, I'm displaying the records comedy and fiction:

when the user clicks on comedy, humour.php has to be shown and the same with the other.

If somebody feels that I'm doing wrong, pls guide me.

I wonder if there is something to do with the field types, like my PARENTTOPIC_CONTENT is of text type.

Thanks everybody for your time

Here is the source code:


<?php

include "../dbconnection.dam";

$select_query = "SELECT PARENTTOPIC_NAME FROM topic ORDER BY TOPIC_ID DESC LIMIT 10";  
$result = mysql_query($select_query); 
$numrows = mysql_num_rows($result); 
while($row = mysql_fetch_array($result)){

?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>humor</title>
</head>
<body>

<table border="1" width="100%">

  <tr>
      <td width="100%">&nbsp;
 <?
	echo "<a href=".$row[PARENTTOPIC_CONTENT].">".$row[PARENTTOPIC_NAME]."</a>";
?>

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

Weedpacket

Now when I find myself making a mistake like this, I use the little clear space on my desk labelled "bang forehead here".

SELECT PARENTTOPIC_NAME FROM topic ORDER BY TOPIC_ID DESC LIMIT 10

You're not asking for PARENTTOPIC_CONTENT

$row['PARENTTOPIC_CONTENT'] is hence empty, hence the URL is empty, hence your server brings up a file listing of the current directory (because no file was asked for).

gottes_tod

try correct your code

<?php

include "../dbconnection.dam";

$select_query = "SELECT * FROM topic ORDER BY TOPIC_ID DESC LIMIT 10";  
$result = mysql_query($select_query); 
$numrows = mysql_num_rows($result); 
?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>humor</title>
</head>
<body>

<table border="1" width="100%">

<?
    while($row = mysql_fetch_array($result))
    {
?>

  <tr>
      <td width="100%">&nbsp;<a href="<?
    echo $row["PARENTTOPIC_CONTENT"]."\">".$row["PARENTTOPIC_NAME"]."";
?></a>
</td>
  </tr>
<?
    }
?>

</table>
</body>
</html>

minds_gifts

Thats the style of a perfect guru.

Thanks weed!