Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mroos81

    PHP Newsletter troubles

    Excellent! That did the trick, it's working just fine now! Thanks so much for all your help!
  2. mroos81

    PHP Newsletter troubles

    You were right, that was the reason why it wasn't sending anything. It sends mails now, but in the strange 'pyramid' kinda way I had before... I tried it in tow different ways: //way one $interestMessage .= '<P>'.$message[$sRow["interesse_id"]]; //way two $interestMessage =...
  3. mroos81

    PHP Newsletter troubles

    Hello, Thanks again for your reply! :-) I allready figured out myself what dot was wrong. But it still isn't working OK. When I send a message, everything seems to work fine, and just one e-mail is sent to everybody on the list. But - only the general text is in it and none of the...
  4. mroos81

    PHP Newsletter troubles

    Once again - thanks very much for your help, I really appreciate it! You're right, I have multiple records per userID. Also kinda my mistake, it's a bit difficult for me to explain everything in a clear way in English. Anyway, I copied your example and I still got a little error. If I open the...
  5. mroos81

    PHP Newsletter troubles

    Thanks again for your help! You were right, this solved the 'pyramid-effect'! :-) But now, a new mail is sent for evey interest. So if somebody is signed up for interest 1 and 2, he now receives 2 seperate e-mails, both with the general text, but one with just text 1 and the other one just...
  6. mroos81

    PHP Newsletter troubles

    Hello, Thanks for your advice, it helped me out quite a bit! The system now actually sends mail to every address in the database. But it's still not quite working the way I want it. Let me sketch a situation here. Let's say this is the result of the query: SELECT personen.persoon_id...
  7. mroos81

    PHP Newsletter troubles

    Hello everybody, I'm working on a PHP newsletter system for my website. As people subscribe for the newsletter, they need to choose their fields of interest from a list of 5. They need to pick at least 1 interest, but can also pick all 5. If a newsletter is sent, there is a text that everybody...
    • mroos81
    • Thread
    • Replies: 12
    • Forum: PHP
  8. mroos81

    Problem with PHP newsletter system

    Hello, Thanks very much for your reaction. I tried it immediately, but when I run the script, I get the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource etc, etc... Do you know how this error is caused? Does it have something to do with the...
  9. mroos81

    Problem with PHP newsletter system

    Hello everybody, I'm working on a newsletter system in PHP4 & MySQL. People can subscribe for the list, and can choose their areas of interest. There's a minimum of 1 and a maximum of 5 interests. I allready have the main mailingsystem working, but I want it a little more complex. I've...
    • mroos81
    • Thread
    • Replies: 3
    • Forum: PHP
  10. mroos81

    Sorting of data in report

    Hello everybody, I created a report in Crystal Reports 7. I connected the report to a CRM-system which is only compatible with CR7. A client-version of CR7 is included with the CRM-system. I want the data in this report sorted in a special way. To achieve that, I manually adjusted the...
  11. mroos81

    Sorting of data in report

    Hello everybody, I created a report in Crystal Reports 7. I connected the report to a CRM-system which is only compatible with CR7. A client-version of CR7 is included with the CRM-system. I want the data in this report sorted in a special way. To achieve that, I manually adjusted the...
  12. mroos81

    Can I remove spaces from phonenumbers?

    Hello Reebo, Thanks for your advice. Not sure if I actually had to download those files, but I changed the formula a little, and now it's working OK. I used your first example, and changed it this way to get it work: Local StringVar SMS := {REL_PERSOON.TELEFOONMOBIEL}; SMS :=...
  13. mroos81

    Can I remove spaces from phonenumbers?

    Reebo, Thanks for your reply. Yes, the phonenumbers are stored as strings. The name of the database-field is REL_PERSOON.TELEFOONMOBIEL I tried to put your examples in a formula-field, but I get an error with both. Maybe it is good to repeat that I'm working with Crystal Reports 7. With the...
  14. mroos81

    Can I remove spaces from phonenumbers?

    Hello everybody, I'm creating a report in Crystal Reports 7, for export of names and phonenumbers to an SMS-application. The problem is that the phonenumbers are in my system in many different formats. A few examples: 06 51238745 06 - 51238745 What I need to do is remove the spaces from the...
  15. mroos81

    Change format of sting field

    Hello I've the following problem: When I add a character to a numeric field in a formula field it becomes a String field. ( example: 'X'+ToText ({Table.Field_ID}) ) I don't want the Field_ID to have a thousands separator, but because I changed it to a String field, it isn't possible to change...
  16. mroos81

    Selection-problem

    Hello everybody, I have the following problem with Crystal Reports formulas (I'm working with version 7). I want to make some sort of SQL-selection, a selection with conditions. So far, I have the following formula: if {OPL_UITVOERING.STATUS_CODE} = &quot;DE&quot; or...

Part and Inventory Search

Back
Top