How to link from one row column to other columns

[albynas]

Hi,

I need to solve this question. Lets say I have table new with columns id, title, text, date.

I fetch one column:

while ($row = mysql_fetch_array($result)) {

echo $row["title"].'<br>';
}

And now I need to make link from column 'title', that when I click on it, I can see 'title', 'text' and 'date' of this row.

Thanks.

[albynas]

Ok,
I tryed this code:

while ($row = mysql_fetch_array($result)) {

echo '<a href ="?s=view&id='.$row['id'].'">'.$row['title'].'</a>'.'<br>';
}
if ($s == "view") 
		{

			$sql="SELECT * FORM news WHERE id=.$id";
			$result = mysql_db_query($dbname,$sql);
echo '<table>';

while ($row = mysql_fetch_array($result)) 
		{
			echo '<tr>'.
			'<td>'.$row['title'].'</td>'.
			'<td>'.$row['text'].'</td>'.
'</tr>'.
'</table>';
}
		}

It's not working 🙁

[obrienkev]

OK. Try this...

This sets the link with id used as identifier..

<?php

while($row = mysql_fetch_array($result))
{
 echo '<a href="download.php?id='.$row['id'].'">'.$row['title'].'</a>';
}

?>

Then download.php is called with id set to whatever link was clicked...

<?php

$id = $_GET['id'];

$query = "SELECT title, text, date ".
			 	 "FROM tbl ".
				 "WHERE id = '$id'";

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
 echo $row['title'];
 echo '<br />';
 echo $row['text'];
 echo '<br />';
 echo $row['date'];
 echo '<br />';
}

?>

Hope this helps. Didn't test it.

Kevin.