| This does not quite work, although it is cleaner. It's only grabbing one record. How does LIMIT work, exactly? My understanding was that it would grab only 7 items that met the criteria, which is why I was confused. Only ONE item is going to meet the criteria at any given time of the day, I just want that item and whatever the next 7 items are, although I know that the next items will NOT meet the timestamp criteria.
Or am I understanding this wrong? |