Hello,
This is probably really simple, but I can't figure it out. I have a rather simple query in "List Page: Before Process":
global $conn;
$strSQLSelect = "SELECT eventid FROM events_eligibility_list WHERE userid = '".$_SESSION["UserID"]."'";
$rsSelect = db_query($strSQLSelect ,$conn);
while($data =db_fetch_array($rsSelect))
{
SOMETHING?
}
I need to query all of the eventids from the logged in user and make an array with it and then use "IN" in the WHERE statement in List Page: Before SQL Query.
So, in Before Process, the query will get all of the eventid's from the logged in user from the events_eligibility_list table. Then an array will be created in this format: (doing some imploding/exploding?)
('5','10','21','35') ....assuming this logged in user has 4 records in the events_eligibility_list table.
I then need to use this array using a session variable in the List Page: Before SQL Query page:
$strWhereClause = whereAdd($strWhereClause, "(eventid IN '(' + $_SESSION['array'] + ')' ");
Thank you in advance once again!
Brian