listing database info then linking to it

[Rakim]

hi all...

ive recently made a script for game reviews BUT there all on one page and i would like to have them so they display links to them without having to make a new php page for every review..

i.e.

Click Here For Battlefield 1942 Review

then when it is clicked it can read the info from the database and display it on a page for me its the linking to a field that i am unable to do

i think its something like...

<a href=reviews.phpname=review=ID>$gamename</A> but i dont think it is anything like that as that is just an example and it kinda very very low level explains what i want. thanks to anyone who can help i do need this for loads of my scripts and am having a hard time getting it like i also need it for a read more link on my news script.

[NoFear]

Have you tried this?

<a href=reviews.php?name=$var&somethingelse=$anotherVar>>$gamename</A>

[Rakim]

thanks dude

[Rakim]

errrm dude i tried and tried but cant do this could u add it to my code and post the whole thing on here please as i cannot figure it out and btw is there a specific code i need in the other page aswell ?

my code for listing & linking

<?php 

require("C:\Program Files\Apache Group\Apache\htdocs\config.php");  

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
/* We have now connected, unless you got an error message */ 
/* Lets extract the data (news) from the database */ 
$query = "SELECT id, title, url, des, author, date FROM php_links ORDER BY id DESC"; 
$result = mysql_query($query); 
/* Here we fetch the result as an array */ 
while($r=mysql_fetch_array($result)) 
{    

/* This bit sets our data from each row as variables, to make it easier to display */ 
    $id=$r["id"];
    $title=$r["title"]; 
    $url=$r["url"]; 
    $des=$r["des"];
    $author=$r["author"];
    $date=$r["date"];
/* Now lets display the news */ 
echo "
Link: <a href=show.php?name=$title&id=$id>$title</A>
<br>
"; 
}
mysql_close($db); 

?>

and here is my code for displaying everything on there....

<?php 

require("C:\Program Files\Apache Group\Apache\htdocs\config.php");  

$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db ($db_name) or die ("Cannot connect to database"); 
/* We have now connected, unless you got an error message */ 
/* Lets extract the data (news) from the database */ 
$query = "SELECT id, title, url, des, author, date FROM php_links ORDER BY id"; 
$result = mysql_query($query); 
/* Here we fetch the result as an array */ 
while($r=mysql_fetch_array($result)) 
{    

/* This bit sets our data from each row as variables, to make it easier to display */ 
    $id=$r["id"];
    $title=$r["title"]; 
    $url=$r["url"]; 
    $des=$r["des"];
    $author=$r["author"];
    $date=$r["date"];
/* Now lets display the news */ 
    echo "
Link ID: $id<br>
Site: <a href='$url'>$title</a><br>
Description: $des<br>
Author: $author<br>
Date Added: $date<br><br><hr>
"; 
} 
mysql_close($db); 

?>

please help me asap thanks in advance

EDITED : sorry i forgot to add php tabs