Mysql record lookup from hyperlink?

[Anon]

Greetings,
I need to be able to lookup a specific record from a Mysql database and post that data into a php page. That part I can do.

I have a standard html page with a list of items each with their own hyperlink.

I would like to pass the necessary variables from the hyperlink to the php page that will then display the database data.

My php page will already know which database and table to use, but I would like to somehow pass the 'record' and 'field' id from the hyperlink.

Is this possible or is there a better way?

Thanks!

Frank Maestas
[e-mail]

[Anon]

Ok Let me see if I understand you You want to generate a list from where are they hard coded if so then you need to hard code the vars if you are pull them from a DB then you could just as easy list he vars

But hte key here is where is the list coming from

[Anon]

just pass the ID of the record in the querystring :

detail.php?id=<? echo $row['someID']; ?>

then, on the detail-page, your query would be like :
$result=mysql_query("SELECT * FROM yourtable WHERE someID='".addslashes($id)."'");

or something similar...

[Anon]

I figured it out.

In the static page I setup the link like:

<a href="pagename.php?id=7">Test link</a>

On the PHP page ("Select * From tabelname Where id=$id");

Works great.

Thanks for the help guys!