Database query

[Anon]

Hi
Very very new at this--I have a database--MySql--let's say there are 300 unique entries in the database in 20 columns. If I wanted to extract only one unique entry and I wanted it to be extracted by the use of a hyperlink. Is there a basic script format (PHP3) that can accomplish this without the use of a search box?

Maybe an example of what I am trying to accomplish would make this easier to
explain--here is a hyperlink to a visual description of my problem.

http://www.rpvnet.com/question.html

Thank you
Preston
[e-mail]

[lucianoes]

I am not sure I understand what you want, but it sounds very simple:

$dbquery = "select color, size, price, material, ref, style, condition from table where ($item = '$ID)";
(considering ID will always be the same like you say!)

your link should be 
<a href="http://www.domain.com/script?item=1" target="_self">Item1</a>

or 

<a href="<?php echo "$PHP_SELF".'?item='."$item"; ?>" target="_self"><?php echo $item; ?></a>

Good luck,
    Luciano ES
    Santos, SP - Brasil