criticman

I need to send e-mail from our website via our hosted Exchange server, which requires SSL connections (for Outlook 2007, it specifies to use TLS if that matters any) I have the SMTP address for use with the Exchange server. I can telnet to it on the SSL port (465) from our Linux server and it connects, responds validly as being our Exchange box. It HAS to be over SSL. I found an "SSL using PEAR:Mail" tutorial, tried the following: <?php // PHP Pear Mail Extension require_once "Mail.php"; $from = "XYZ <x@yz.net>"; $to = "XYZ <x@yz.net>"; $subject = "Hi!"; $body = "Hi,\n\nHow are you?"; $host = "smtp.yz.net"; $port = "465"; $username = "x@yz.net"; $password = "XyZxYz"; $headers = array ('From' => $from, 'To' => $to, 'Subject' => $subject); $smtp = Mail::factory('smtp', array ('host' => $host, 'port' => $port, 'auth' => true, 'username' => $username, 'password' => $password)); $mail = $smtp->send($to, $headers, $body); if (PEAR::isError($mail)) { echo("<p>" . $mail->getMessage() . "</p>"); } else { echo("<p>Message successfully sent!</p>"); } ?> And I get the following error: [pre]authentication failure [sMTP: Invalid response code received from server (code: 530, response: 5.7.0 Must issue a STARTTLS command first)][/pre] Our Exchange provider could care less, as our Outlook and OWA, as well as ActiveSync e-mail is working just fine... I am tired of routing my employer's web email through my personal company's web server (using standard SMTP auth on a Linux box) instead of using their server, especially since users will randomly end up missing a message depending on the receiving mail server and whether or not is says the sender is forged (showing company's email addresses, using my server instead).

Yeah. I'll check. I CAN pull this off (hell, written full blown e-commerce sites and corporate intranets) but not on my time crunch with other active projects, LOL. Thanks! I'll search there and hopefully find something.

Anyone know of a good, ready-made (FREE) PHP file browser (possibly with Javascript/"AJAX" to make navigation smoother)? I need it to operate like this /mysite.com/httpdocs/filebrowser.php <- file users hit (i.e. www.mysite.com/filebrowser.php) /mysite.com/files/ /mysite.com/files/A/fileone.tiff /mysite.com/files/A/filetwo.tiff /mysite.com/files/B/filethree.tiff User sees: A B They click "A" and see: fileone.tiff filetwo.tiff So the files themselves need to NOT be web accessible. I need PHP to load the directory structures, allow users to "browse" by clicking a folder to view sub-folders, and ultimately click the file and load it in the browser for the user. If it helps any, these will be .tiff files. Maybe a PHP download script exists that does this? You know, that masks the actual file URL to prevent direct-linking? PLEASE HELP! On a deadline and this came up out of nowhere! Thanks!

[!--quoteo(post=318395:date=Nov 14 2005, 12:13 PM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ Nov 14 2005, 12:13 PM) 318395[/snapback][/div][div class=\'quotemain\'][!--quotec--] [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM ProductList WHERE cat = '$cat' AND subcat = '$subcat' AND RIGHT(itemNumber,1)='S' ORDER BY brand, prodName, details ASC [!--sql2--][/div][!--sql3--] Thanks. I posted this on several forums, same response on all. Not all item numbers follow that format, so I will have to restructure the table when I have the time. For now they will have to deal with what I have given them.

[!--sizeo:5--][span style=\"font-size:18pt;line-height:100%\"][!--/sizeo--][!--fonto:Arial Black--][span style=\"font-family:Arial Black\"][!--/fonto--]SOLVED - Thanks[!--fontc--][/span][!--/fontc--][!--sizec--][/span][!--/sizec--] So I am working on a project for a company doing an online e-commerce site with a full product catalog. I had things going just fine until they put some interesting requirements on me. This required restructuring of the MySQL table. So, I now have an issue. I am working on the "browse products" page. I have no issue displaying categories, then subcategories, then listing all items under them. The issue is there are several item #'s for each set of item. Items have different sizes, and unfortunately each size has its own item number. I.E. ONG76515-XL, ONG76515-L, ONG76515-S, ONG76515-M What the client now wants (contrary to original request and I do not have time to redo the MySQL tables) is to only display ONE item number on the browse page per set of similar item #'s (basically, show size S and hide sizes M, L, XL until you get to the product detail page). So, right now my query is thus: SELECT * FROM ProductList WHERE cat = '$cat' AND subcat = '$subcat' ORDER BY brand, prodName, details ASC Is there a somewhat efficient way to go about doing this within the SQL query? I would like it to be optimized to the query so that I am not creating tons of overhead by loading 100's of item #s and then hiding all but one per item # set using PHP. Any help is more than appreciated. I am just stumped and in need of sleep. Project is due Monday AM.