so that I could do something like this: $sql->execute($item1,$item2,$item3);

You have to pass exactly as many arguments to execute() as you have placeholder. Fortunately, $sql->execute(@items); will do the trick, assuming you've populated @items with the right number of values.