Good day.
I am having trouble finding the right way to do a addwhere with a array of items ie. ID's
my code looks as follow
$ItemID = $_POST['ItemID'];
$sqlQuery = new SQLSelect();
$sqlQuery->setFrom('products');
$sqlQuery->selectField('ModelNo', 'ModelNo');
$sqlQuery->selectField('ImageURL');
$sqlQuery->selectField('Manufacturer', 'Manufacturer');
$sqlQuery->selectField('RetailPrice','RetailPrice');
$sqlQuery->addWhere(array('ID' => $ItemID));
$Amounts = $sqlQuery->execute();
As the code is it works for getting the information from 1 ID but if i have say 2 or 3 ID's in there it does not work
I want to know is there a better way to do the addWhere where i can have multiple ID's which will call their respectable fields?
Any help will be appreciated
Thanks
Skullies