A hyperlink for each record from the table

minds_gifts

hi,

I'm displaying on my form the records from a table.I would like to make a hyper-link for each of the record.I wonder, how can i do it.Each record i display from the table will have a different link to be opened.

Ex:
I display from the table the following records:

first record
second record
third record
......and so on----

Now, when i click first record, a page is displayed.

lly, when i click the second record, a different page is opened.

How can i accomplish this one??

Here is my code:

<?php

//DB connection	
	$select_query = "SELECT PARENTTOPIC_NAME FROM topic ORDER BY TOPIC_ID DESC LIMIT 4";  

	$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 "<br>\n", " $row[PARENTTOPIC_NAME]"; 

?>

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

Thanks in advance for your help

ednark

whatever is inside your while loop will be repeated for each result...

for each result you just want a row ...

so make sure only the

is the loop....

move the <html><body><table> stuff outside of it

does that make sense

minds_gifts

Thxs ed.

well, could you be more precise.

If i make the while loop only for the records to be displayed not to the entire stuff, how could i make an hyperlink??

could you pls make some modification in the code could yu give me an ex:

thanks once again

ednark

i was talking about something like this...

<?php
//DB connection    

    $select_query = "SELECT PARENTTOPIC_NAME FROM topic ORDER BY TOPIC_ID DESC LIMIT 4";  

    $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%">
<?php
    while($row = mysql_fetch_array($result)){
?>
  <tr>
    <td width="100%">&nbsp;
    <a href="<?php echo "{$PHP_SELF}?parenttopic_name={$row[PARENTTOPIC_NAME]}"; ?>"><?php echo $row[PARENTTOPIC_NAME]"; ?></a>
    </td>
  </tr>
<?php
    }
?>
</table>

</body>
</html>

minds_gifts

well, i tried to put it in this way:

<?
echo "<a href=".$humor001.">".$rowPARENTTOPIC_NAME]."</a>";
	?>

It seems to be working, but not in the way i liked it to be.well, for each record, i display, there has to be a link and each displays a different page.For ex, in the above one, the first should display, humor001.php page.If i add humor001.php, it seems to be not working and if i remove the extension, .php it displays the folder contents.

I'm going crazy.

could somebody please help me.

Thanks once again.

milind24

Try this

<?
echo "<a href=".$humor001." target=\"_blank\">".$row[PARENTTOPIC_NAME]."</a>";
    ?>

minds_gifts

Nope, its'nt working:-(

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

everytime, only humor001.html is opening.I want for each record that i'm displaying from the table to open a different page.

Hope somebody would tell me how i can do that.

well, a small correction, the filenames like(humor001.html) are not in a table.They are stored in a folder.can i do it in this way or should i necessarily store in the table.I would like to do it in the former way.
Thanks once again