How do you serve up the other data from the database? Are the ZIP files in a directory that is accessible from the web?
In the simple case, all you need to do is create an <a href="zipfileURL">Download Design</a> construct in your output from the php script. So if the column returned from the MySQL query is called ZIPFile, and you have a rowset object $row, you would use something like: $DownloadURL = $row->ZIPFile; echo "<a href='$DownloadURL'>Download Design</a>"; for each line item. Of course you can use an img tag instead, but the principle is the same. HTH, Tore. ----- Original Message ----- From: "Stitchin'" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 9:34 PM Subject: Reference to a downloadable file > I am building a web application for my embroidery business .... which is > basically a catalog program within a members only subscription site. > > On each line item, I want to have a spot for a zip file for members to click > on to download the embroidery design file. I have a field in my mySql > database to hold the filename of that zip file. The PHP and mySql books I > have here don't have any examples of a web page with a download link and how > to have it show on the detail lines being brought up with a query on a > specific design category. Does anybody know of any resources on the web > that may show an example of this for PHP and mySql? > > Renee Toth > Stitchin' Up A Storm > www.stitchinupastorm.com > > -----Original Message----- > From: Stefan Hinz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 12:37 PM > To: Amy & Joseph Kormann > Cc: [EMAIL PROTECTED] > Subject: Re: Continuing problem > > > Ami, Joseph, > > > I'm running the Windows mysqld application and attempting to connect to > > it using the CygWin libraries without any success. The mysql and > > winmysqladmin all connect fine to mysqld. The error I get from my > > application is 'Error 2002, cannot connect through socket MySQL' or it's > > about not finding port 3306 or it cannot find /tmp/mysql.sock (which is > > never created by the mysqld even after specifying it in my c:\my.cnf and > > ~/.my.cnf files). > > Apparently, this is a socket problem. You have no Unix socket on your > Windows MySQL server through which to connect. Try to use TCP/IP, by > connecting with the host specified, where host is something else but > 127.0.0.1 or localhost; like this: > > mysql -h <machine_name> > > Where machine <machine_name> is the host name of your Windows machine. > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > [filter fodder: sql, mysql, query] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
