Comments by dibdab (Top 13 by date)

I am not very sure how to code it yet.. but basically I need to retrieve the value from the database with the query.. and then combine them with ";" and send them an email..

Thank you for the resources! and I am using smtp.live.. because thats what my school taught us..

YES! I did that part and solved it! Thank you for helping me with the database part! now I have to move on to the ASPX.CS part where i keep getting the error.
Is it possible to get many email addresses from database and send an email to them?
like in the code above where i string query the email addresses and then use the string query to send the email to those email addresses

Yes.. Both of the table have meeting_id... I tried but it doesn't seem to help
I do not have email id in my table
Oh.... Attendees does not have meeting_id

I managed to change it.. It works.. but there is no data.. I did load data in already.. Is there a mistake with my joining ?
SELECT email, attendees_email
FROM Staff S INNER JOIN Staff_have_meetings SHM ON S.staff_id = SHM.staff_id
INNER JOIN Meeting M ON M.meeting_id = SHM.meeting_id
INNER JOIN Attendee_have_meetings AHM ON M.meeting_Id = AHM.meeting_id
INNER JOIN Attendees A on A.attendees_id = AHM.attendees_id
AND M.meeting_id =14;

yea... I am missing a Attendees

SELECT email, attendees_email
FROM Staff S INNER JOIN Staff_have_meetings SHM ON S.staff_id = SHM.staff_id
INNER JOIN Meeting M ON M.meeting_id = SHM.meeting_id
INNER JOIN Attendees A ON A.meeting_id = M.meeting_Id
INNER JOIN Attendee_have_meetings AHM on A.attendees_id = AHM.attendees_id
AND M.meeting_id =16;

I tried this but this is wrong... What part am I doing it wrong?
It says the "Invalid column name 'meeting_id'.
"

I have solved the problem already , it turns out the login page Session was not well done! Thanks for your help! But i still have other problems in other pages.. Sigh

yup.. it is an id from the database , as well as the id where the user logs in with

Hi, I recently updated my code.. although it still doesnt work, i am still trying to figure out why.