I can't get my query to work quite right.
Basically, it's a personal calendar using MySQL that allows people to add events they have announced to others on to their calendar and to add events that others have announced on to the same calendar.
Here's my database structure:
TABLE: activities
This lists all the activities the activities
AID = Primary Key (Activity ID)
ADay = day of event
AMonth = month of event
AYear = year of event
AUserName = organizer's username
TABLE: clientactivities
This lists everyone who has signed up for an event. This includes
CAID = Primary Key (clientactivity ID)
CUserName = Username of signee
AID = Activity ID of event (Foreign key from the above table).
Here's my query so far.
"SELECT * FROM activities WHERE activities.CUserName='$CUserName' AND ADay='$d' AND AMonth='$month' AND AYear='$y' AND activities.AID = clientactivities.AID"
This query as is, doesn't work.
Thanks for your help.
Mike
Basically, it's a personal calendar using MySQL that allows people to add events they have announced to others on to their calendar and to add events that others have announced on to the same calendar.
Here's my database structure:
TABLE: activities
This lists all the activities the activities
AID = Primary Key (Activity ID)
ADay = day of event
AMonth = month of event
AYear = year of event
AUserName = organizer's username
TABLE: clientactivities
This lists everyone who has signed up for an event. This includes
CAID = Primary Key (clientactivity ID)
CUserName = Username of signee
AID = Activity ID of event (Foreign key from the above table).
Here's my query so far.
"SELECT * FROM activities WHERE activities.CUserName='$CUserName' AND ADay='$d' AND AMonth='$month' AND AYear='$y' AND activities.AID = clientactivities.AID"
This query as is, doesn't work.
Thanks for your help.
Mike