Hi...great software you created there! But I'm having a little problem.
I created a databases containing 3 tables ( students, courses, whowhat). By checking the checkboxes in front of all courses I'd like to have the opportunity to send a message to each of the students who follow that course. When the page for the courses is created I can see all possible courses with a checkbox in front of it ( the way I want it...so far so good) .
I also inserted a text field already, but I want the message that I type in the text field to be sent to all students who follow that course.
For example, a working SQL statement is (this works for me when I do not load the courses dynamically, but just create the script myself, writing my own php code, not using phprunner)
Don't bother about the structure...only the last part is important:
[codebox]SELECT student.Mail FROM students, courses, whowhat WHERE students.Name = whowhat.Name AND whowhat.CourseId = courses.Id AND Course= 'Economics';[/codebox]
But is this statement , "economics" should be replaced by the (variable) word that is loaded next to the checkbox. I thought you called the checkbox : selection[]. But I don't know how to deal with it.
I also tried to load a list dynamically in Dreamweaver and this worked as well (the chexbox name was checkgroup1)
[codebox]....AND Course= . $_GET['checkGroup1'].[/codebox]
I (first of all hope you understand my question and) hope you can help me with this issue.
Tnx a lot in advance,
Ingmar