get filename problem

thered

I have a site which, on clicking on a link, opens a popup with extra
details. One of the details is price. This price information is held
in a database so I should be able to code it to insert it.

I can do this without problem, if I type the filename in the query
string, but how do I get the filename automatically?

Should I be looking to do it another way?

Is there a function I could use to get filename?

Here is my coding:
<?php

$user="username";

$db = mysql_connect("localhost", $user, "password");

mysql_select_db($user,$db);
$data="SELECT * FROM full_sales WHERE file = \"104oak.php\" ";

the line above is where i have problem - what do I substitute
"104oak.php" with?

$result = mysql_query($data,$db);

$price=mysql_fetch_array($result);

echo ("On Sale at ".£.number_format($price["price"]));

Here is site: www.pgnpropertyservices.co.uk/sales.php

Regards,

devinemke

the basic idea here is store everything in the database (not just the price) and pass the Primary Key field to the script to fetch the appropraite record. for example:

a list of links:

<a href="getrecord.php?id=1">Yearby</a>
<a href="getrecord.php?id=2">Stanghow</a>
<a href="getrecord.php?id=3">Woodside</a>
etc...

then in getrecord.php

mysql_connect('host', 'username', 'password');
mysql_select_db('database');

$result = mysql_query('SELECT * FROM table WHERE id = ' . $_GET['id']);
$row = mysql_fetch_assoc($result);
print_r($row);