Data Sets
Table "users"
username | password | vote_count
joe | 343423 | 3
mike | jhgjjh | 1
phil | sdfg4 | 2
Table "votes"
username | team | week
joe | Bears | 1
mike | Colts | 1
joe | 49ers | 1
phil | Bears | 1
I need to match the users database with the votes database to compile who has not voted their assigned vote count in the desired week....
This is what I have so far...and it's not working
$query="SELECT users.username FROM users
LEFT JOIN surpool06 ON users.username=surpool06.surpool_username
WHERE surpool06.surpool_username IS NULL";
It is not working because I can't tell it what week to look for and also i need to know assigned votes versus actual votes....
Please Help!!
Thanks in advance!