[EMAIL PROTECTED] wrote: > I have a pdfs/documents saved in a field called 'content' on my db and I > want to create an active hyperlink so users can download. any ideas how I > can achive this. > > I am sure it is simple but cannot find an easy example posted. > > thanks, > > Ross
Hi Ross, Answered you in the PHP group, but this is a different query. Here is the PHP and MySQL I use to do the same thing. I see no reason not to use HTML to create links to download your pdf files by the way. It keeps things simple. You do mean that you keep the filenames in the database, right? Feel free to email if you want some explanation, as it seems we are doing the same thing. /* *Construct MySQL query */ $query = array_pop($queries); $select = "SELECT files.*"; $from = "\nFROM files, assoc, words"; $where = "\nWHERE words.word = '" . $query . "' AND "; $where .= "words.id = assoc.word_id \nAND"; $where .= " assoc.file_id = files.id "; foreach ($queries as $q) { $from .= ",\nassoc AS assoc_$q, "; $from .= " words AS words_$q"; $where .= "\n AND words_$q.word = '" . $q . "'"; $where .= "\nAND \nwords_$q.id = assoc_$q.word_id \nAND "; $where .= "assoc_$q.file_id = files.id "; } if ((isset($startdate) and isset($enddate)) or ($startdate != "" and $enddate != "")) { $where .= " \nAND \nfiles.startdate <= '$enddate' \nAND "; $where .= "files.enddate >= '$startdate'"; } $order = "\n ORDER BY files.series, files.volume"; /* * connect to database */ $conn = mysql_connect($dbhost, $dbuser, $dbpass); if (!$conn) { die("couldn't connect to $dbhost"); } if (!mysql_select_db($dbname, $conn)) { die(mysql_error($conn)); } /* construct query */ $selectq = $select . $from . $where . $order; echo " <!--MySQL query: $selectq -->\n"; $res = mysql_query($selectq, $conn); if (!$res) { die(mysql_error($conn)); } /* * Output the results to browser */ /* * Create HTML table for results */ echo "<table class=\"results\">"; echo "<tr><td><strong>Source</strong></td><td><strong>Volume</strong></td><td><strong>Start date</strong></td><td><strong>End date</strong></td></tr>\n"; while ($line = mysql_fetch_array($res, MYSQL_ASSOC)) { echo "<tr><td><a href=\"$line[file]\">$line[series]</a></td><td>$line[volume]</td><td>$line[startdate]</td><td>$line[enddate]</td></tr>\n"; } mysql_close($conn); echo "</table>"; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]