Mysql and php help with variable

[ianhg]

Hi,

I am very new to this. Can someone point me in the right direction please. I have mysql database which contains a variable $pricelist. The client is registered via an admin area. Is sent the login (email and password).

Once logged in they see their details. All this works fine. Each client will have a different price list, total number of price lists options will be about 10. In the database the variable will return pricelist1.pdf or pricelist2.pdf etc. This is also OK.

My question is how do I provide a hyperlink to the pricelist1.pdf file (which is located on the server) for the client to view and download if they wish?

Thanks in advance.

 

[Pikachu2000]

Pseudo-code:

<?php
$query = "SELECT `price_list` FROM `table` WHERE `user_id` = {$_SESSION['user_id']}";
$result = mysql_query( $query );
$array = mysql_fetch_row( $result );
echo "<a href=\"/path_to/directory_with/pdf_files/{$array[0]}\">Your Pricelist</a>";

[ianhg]

Thanks very much for the speedy response :-)

I think I see what the code is doing, but do I not need to create the array?

At the moment the $pricelist field just gets entered as pricelist1.pdf or pricelist2.pdf.

Thanks

[Pikachu2000]

You need to access the result resource returned by mysql_query somehow. It could also be done with mysql_result, but the end result is the same. Most people just find the mysql_fetch_* functions easier to deal with.