Guys, could you please fill in the blank for me here? I need to do a select statement that will return only events whose MINISTRY_ID = $id. So I use the query below...
$query="SELECT * FROM EVENTS WHERE MINISTRY_ID='$id'";
This works great if there is only one ministry per event, but more than one ministry can be involved in an event, so a given MINISTRY_ID could look like 4,20,40,44 (four ministries separated by commas).
How can I do a select statement that will find only events with a MINISTRY_ID of "4"?
Thanks,
Wes Ratcliff
$query="SELECT * FROM EVENTS WHERE MINISTRY_ID='$id'";
This works great if there is only one ministry per event, but more than one ministry can be involved in an event, so a given MINISTRY_ID could look like 4,20,40,44 (four ministries separated by commas).
How can I do a select statement that will find only events with a MINISTRY_ID of "4"?
Thanks,
Wes Ratcliff