@Diafol - I am trying to get all records from the db where lsecure = $var
@matrixdevuk - Thanks, I will give that a go and let you know the results
Sorry for the late reply,
OK if you want all records, then you probably need fetchAll as matrixdevuk shows. However this is useful when you don't want to process the data further with php. Although you can use array functions like array_map() etc to do so if you want. Otherwise you use the fetch method in a while loop.