wayne

I noticed a new button in cpanel >backups which allows you to download a weekly systembackup. When are these backups generated? Thanks Wayne

That is great news. I use PHPmyadmin alot and was told about 6 months ago that I cannot get in through my ssl (I am a reseller and this is an account for a client). I was also told that there was no way to encrpt my connection to this account so I have been using it through a regular http connection and have always worried about my password being sent in plain text. Now I can rest easy. Thanks

Using PHP/mySQL Have a database of registrants and one field is their email address.Want to allow event director to log in to a secure area, fill out a form with the message and be able to send the message to all the registrants to his event. I created a form with 2 fields. From address (this will be the event director's address) and a text field for the content of the email. These are sent to the variables $eventdirectoremail and $body. 2 issues: 1. paragraphs are not kept, when the confirmation page comes up all text just runs together. 2. I want to use the following general format. I can get the data from the database no problem into the variable $emailaddressesfromdatabase. The $eventdirectoremail and $body are grabbed from the form. $headers = "From: $eventdirectoremail\r\n"; $headers .= "Reply-To: $eventdirectoremail\r\n"; // $headers .= "To: $eventdirectoremail\r\n"; $headers .= "bcc: "$emailaddressesfromdatabase"\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "X-Priority: 1\r\n"; $headers .= "X-MSMail-Priority: High"; $mail_subject = "Subject is here"; $mail_body = "$body\n"; mail("$email", $mail_subject, $mail_body, $headers, "-f".$eventdirectoremail); not being sent, any ideas?

$value_var = stripslashes ($value_var); Use to remove slash to display data on a web page. $value_var = addslashes ($value_var); Use to add the slash back to put data to a database. The slash is used to escape the apostrophe otherwise the apostrophe signifies end of the string and you only get Paul in the database instead of Paul's wayne

Just an update. Got everything working again thanks to advice on this thread http://www.totalchoicehosting.com/forums/i...showtopic=24666 and the help desk. As usual service at TCH just ROCKS. Thanks all!!!! Wayne

Bruce I opened a help desk ticket and they fixed something on the server end. All is now working with the -f switch. Thanks all for your advice, as usual service here at TCH ROCKS!!

actually it is any domain that is outside my server. ie I have tried hotmail.com, yahoo.ca and all fail Seems that if I make the address my own domain, I get the mail fine.

I have many "receipt pages" On these php pages I have code that inputs data from a form (that has been passed to my credit card gateway and then back to my page) into my database. I then email the customer a receipt using the mail() command. I have just discovered that no messages have been sent out over the last couple of weeks resulting in about 200 customers with no receipts. In another thread http://www.totalchoicehosting.com/forums/i...showtopic=24666 we have been talking about modifying the mail command with the -f parameter. The apparently tells sendmail to set the envelope address. I have done this however now mail just gets returned when I try and send it to customers with the error: "unrouteable mail domain" I have looked at ultimateFormMail however this is not feasable since I use logic on my page to write to the database and email the customer only when the bank's gateway returns a certain value for one of my variables (ie transaction has been accepted). I was using the command mail($customeremail, $mailsubject, $headers, $fromemail)and all was good in the world. Unfortunately I am going to have to manually send over 200 receipts and counting until I get some solution in place. My page is basically this. if (credit card accepted){ write data to mysql database email customer a receipt dispaly html and include links to other areas of my site } if (credit card not accepted){ display message to try again } Any advice will be much appreciated. Wayne

I am having 2 problems. One of which I have fixed. This is what I have" $fromname = "wayne"; $fromemail = "wayne@here.com"; $toname = "customer"; $toemail = "customer@there.com"; $subject = "subject of email"; $message = "Test message\n"; $message .= "\n"; $message .= "signed\n"; $headers = "From: $fromname <$fromemail>\r\n"; $headers .= "Reply-To: $fromname <$fromemail>\r\n"; $headers .= "To: $toname <$toemail>\r\n"; $headers .= "bcc: $fromname <$fromemail>\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "X-Priority: 1\r\n"; $headers .= "X-MSMail-Priority: High\r\n"; $headers .= "X-Mailer: My script Mailer\n"; mail($toemail, $subject, $message, $headers, "-f".$fromemail); I have noticed 2 problems when I run the script as instructed above. The $toemail address is getting 2 emails. So I removed the $headers entry for the "To" field and now it is fixed (since the $toemail is also in the actual mail() command). HOWEVER I get the mail to $toname bouncing back. This email address is working as it is on my day job email address (on a server not located at TCH if that means anything). I do get the mail at the bcc address (which is an acount on the TCH server running the script). The error in the bounced mail is unrouteable mail domain "there.com" Any help is much appreciated. Wayne

Thanks for the speedy responses. I will edit my scripts and yes I check the email addresses. Wayne

Thanks I have found this reference to the -f switch <?php mail('nobody@example.com', 'the subject', 'the message', null, '-fwebmaster@example.com'); ?> Not sure what the null is. Do I leave this as null? What I want is an email sent out to my customer and to bcc myself. Would this work? <?php mail('customer@example.com', '$subject', '$message', null, '-fmyaddress@****'); ?> Not sure how I would get this to bcc me as well or can I do this?

what about those of us who are using php to send mail (as opposed to those that use a form to receive mail). Is there a secure script available for this??

I have been told by the help desk that my php script which sends out an email receipt is no longer allowed on my server. It was a basic command in the form to mail($recipient,$subject,$body,$from) The reason is that it is sending out mail as nobody which is no longer allowed. I have many many php pages that use this script to send out receipts to customers. Is there a way to use php to send mail and not have it send it a "nobody". I do put a reply address in the $from variable but obviously that is not what is needed. Thanks in advanced.

As an update, I have everything working fine with Moneris. Better news for me is that they now allow debit card purchases through the Interact network. Also ecommerce can send info directly to their gateway. Wayne

probably a permission issue. Go to the Programs folder. In there is a folder called utilities. In there is a utility called Disk utility. Run that. Select your disk and click on the repair permissions tab.

Does the Apple hardware test cd that came with the computer test the USB plugs? Sounds to me like it is your usb ports. You can also run software update to get to 10.3.9 however it may be a waste of time as I still think it's your plugs if you have tried multiple mice and keyboards and you experience the same problem. Wayne

I must say that alot more spam is getting through to me as well (as of about a week ago). Hopefully someone tries the above and posts their experiences. Wayne

Maybe I can approach this from another angle. One table with the following fields: ID TeamName Fname1 Lname1 Fname2 Lname2 Fname3 Lname3 Fname4 Lname4 Address EntryFee Note that teams can have 2-4 members so sometimes the 3rd and 4th name fields will be blank I can then create the simple select statement to display each record in one row as I need. However I like to display on a PHP page a list of all entries in a table with the columns: Fname Lname TeamName sorted by last name. This way people can see who else is registered and this also server as a confirmation of their registration. I cannot figure out how to do this unless I create the second table. The problem with a second table is that if the event director wants to edit a name, then they have to do it twice (once in each table). Wayne

As mentioned, when you install OS X you can run your OS 9 apps in classic mode. However cannot cut and paste between classic and OS X. You also have to set up your printer in classic (I use desktop printer app). You can also hold down your option key (if you are not on a Blue&white G3) when you start the Mac and choose which OS to start in to (as opposed to using system preferences>startup disk which will make the change permanent until you change it back). If you do go to OS X you may want to increase your memory if you have less than 256 Mb. Good Luck

Thanks to both of you for your responses. Good point re the team name field. I will make the change. The reason I want each team in 1 row is because each team pays once and the event director can download as a csv file with one team per row. The last column of the row is the entry fee paid and all is nice and neat. I also have a page where I list all entries along with their team names. Therefore I use the second table for this listing. I will have to rethink how I am doing this. Thanks again. Wayne

I have been reading about left and right joins but cannot figure out how to do the following. I have 2 tables to capture data about a swimming team entry: TEAM TABLE ID TeamName Category Department 1 Dogs male open Sales 2 Hosers male open IT NAMES TABLE ID TeamName Fname Lname 1 Dogs John Brown 2 Dogs Bob Smith 3 Hosers Davey Jones 4 Hosers Mike Smith If I have either of the following statements: SELECT * From team left join names on team.TeamName = names.TeamName or SELECT * FROM team,names WHERE team.TeamName= names.TeamName I get the following recored set Team Category Dept Fname Lname Dogs male open Sales John Brown Dogs male open Sales Bob Smith Hosers male open IT Davey Jones Hosers male open IT Mike Smith What I want is to list them with one team per row like this: Team Category Dept Fname Lname Fname2 Lname2 .... Dogs male open Sales John Brown Bob Smith Hosers male open IT Davey Jones Mike Smith I cannot figure out a select statement that would allow me to do this. Any help, well you know, it would make my day. Thanks all, Wayne

The HEREDOC way is fine however in Dreamweaver, you just get the PHP icon in the WYSIWYG view which makes is less friendly to edit the html as you have to now use code view. So I now do the following and it works very well. <?PHP if(condition){ ?> A BUNCH OF HTML GOES HERE WITH OR WITHOUT PHP EMBEDDED <?PHP } ?> Only if the condition is true will the html be rendered. You see all the HTML in Dreamweaver's WYSIWYG view so it is very easy to maintain. Of course you can also replace <?PHP } ?> with <?PHP } else { ?> MORE HTML <?PHP } ?> AND SO ON Wayne

Anyone have an thoughts on Microsoft's Antispyware? I have installed it and have no issues with it yet. No spyware either. Wayne

Posted my review with pleasure. Wayne

Thanks for your replies. Swiss do use the hosted pay page solution or one of the API's Using the hosted pay page solution about 5% of my transactions fail. They have told me that possible I am sending to many rvars (variables). How are you using them? I have anywhere from 10 - 50 transactions per day. Wayne