display a table entry on a page linked from table

[woodplease]

Hi. i've read the contents of a database to a table, and within that table, for each record, i've created a link to another page to display more information. my problem is that i'm not sure what code needs to go on the other page, to display this extra information. the extra information is from the same table. I know the code would need to read from the url, but thats about it.

my code from the original table is

 

echo "<TD>".$row['refnumber']."</TD>
<td><a href='description.php?id={$row[refnumber]}'>".stripslashes($row[title])."</a></td>
<TD>".$row['platform']."</TD>
<TD>".$row['price']."</TD>
\n";
echo "</TR>\n";

 

When i click the link, i get the following url

/description.php?id=8

 

 

Any help would be great

 

Thanks

[rajivgonsalves]

the code would be similiar to the first page except that the query would have a where clause

 

where `refnumber` = $_GET['id']

 

please note this is only pseudocode

[woodplease]

i thought it would be something like that, except whatever i try, doesnt seem to work

[rajivgonsalves]

if you could show us the code your trying and what error your getting we could help, its too hard to tell what your trying to do if we do not see the code