ianhg Posted February 16, 2011 Share Posted February 16, 2011 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. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted February 16, 2011 Share Posted February 16, 2011 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>"; Quote Link to comment Share on other sites More sharing options...
ianhg Posted February 16, 2011 Author Share Posted February 16, 2011 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 Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted February 16, 2011 Share Posted February 16, 2011 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.