No code here unless required.
I run this tipping site. All user details are in a table called tipping
which stores their id, username, password, email address, score and others.
Than I have tables round 1 through to round 22. (all seperate tables)
This is where users tip to. I have a tipping deadline, however I run this
(maybe I should for what I need)
in each round i have id, username, game1 through to game 8, score (for that
round only) and a column called Misc. Misc is where I know if the user has
tipped or not, on default it's NULL, if they tip it's y.
I want to run a PHP script generally 24 hours before the end of the round
closing that sends an email ONLY to users that have NOT tipped to date on
script running. The email will have details that they have not tipped and a
web-url. Now I am not sure how to do this.
As mentioned below the email address for users are in a different table.
Should I put the email value in the rounds table also? How would I go about
getting a script to do this?
I know I could send a cronjob to execute it on a set say. And I could change
this if the time needs changing in cronjobs. Just need help on the script.
So I need the script to read the desired round and look for the username and
misc. If misc y than ignore it and the username. If NULL than grab the
username and match it with the email address in the other table. Or I could
add the email value in that table if it makes it easier that way.
Preffered email format is Plain-text. But any code that supports HTML is
fine too. As long as it recognises what's HTML and what's not. (example if i
press the ENTER key it must recognise this as a enter and not a space.)
Could anyone please help me here?
Thanks for your time.