Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2007
    Posts
    264
    Thanks
    19
    Thanked 0 Times in 0 Posts

    Still Learning Need Some Pointers

    I can write pretty basic stuff and understand a lot about functions, but the innerjoin/outerjoin has me baffled. Here is what I am trying to accomplish and I don't know if I should keep it in the member table I have or create another table.

    My members registered and use their phone number. I have a script I created that will email the phone number through text. However I want my members to be able to save information and set a specific date to send a text. This is easy enough, I can do this. The thing that I need to figure out is should I have them post this information into another table into my database and have my cron job send the email out when it reaches that date. Now if I were to do this in another table, how do I link their userid to that table so when cronning everything it searches the date from every profile in the second table? Any information would be helpful. Samples would be appreciated, but if I could get a break down that would be cool.

    Thanks you all! Everyone is friendly and helpful on here.

  • #2
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,038
    Thanks
    23
    Thanked 589 Times in 588 Posts
    This is the site that helped me understand (well almost) A Visual Explanation of SQL Joins
    Evolution - The non-random survival of random variants.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •