only one field of one row will be returned

multiple rows will be returned from a query sent with the fetch method in a multi dimensional array

if multiple rows were returned by mysql then multiple rows will be returned by the fetch method in a multi dimensional array, else one row will be returned in a normal array