I have a new issue with this. I now need to do the same search:
$wagespaid = new WA_MySQLi_RS("wagespaid",$horizon_i,1);
$wagespaid->setQuery("SELECT SUM(Amount) AS sAmount FROM WagesPaid WHERE WagesPaid.Weeks IN (?)");
$wagespaid->bindParam("sl", "".implode(",",$_GET['Week']) ."", "-1");
$wagespaid->execute();
However the WagesPaid.Weeks field in the database is a comma separated field with multiple week numbers. So I have multiple week numbers in the url to search and multiple weeks (separated by commas) in the database to search on. Is this possible?