displaying 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.

[eoghain]

What you are looking for is a php script that take in an ID as a GET variable, uses this ID to query the database and display the requested review, post, whatever.

The HTML code that should get generated needs to look something like this:

<A HREF=http://localhost/review.php?id=1>Click Here For Battlefield 1942 Review</A>

Your page that generates this links should query the database for each reviews name and id. Then it should build the above link replacing the number in id=1 and the text between the open and close tag. Finally you'll need the review.php page to do what I listed in the first paragraph.