/** * Expecting a valid id, this will delete the given collection from the database. * * @param cid the id of the collection you want to delete * @return amount of effected rows */ public int deleteCollection(int cid) { String sql = "DELETE FROM " + getTagTable() + " WHERE commentid = '" + cid + "'"; String sql2 = "DELETE FROM taggedImages WHERE collectionid = '" + id + "'"; delete(sql); delete(sql2); return deleteComment(cid); }