So the printing out a line for each person is hard and I'm officially stuck, I used the MAX(time) method and that works for only the most recent obviously, so it only prints out "Christine was last seen at home at [maxtime]".
I tried a few other methods I think the LIMIT method could be a possibility but I wasn't able to incorporate it into my code.
I was thinking maybe there could be a way to have a query for each person to print out their max times but once again I'm not sure how to go about this, any ideas?
About Me
- Christine
- Monaghan/Dublin, Ireland
- I'm a London girl living in Ireland for so many years it's my home now although it has taken its toll on my accent which hasn't got a clue where it's from. I'm a newbie in the area of Web & Graphic design trying to get by and make my imprint on the digital world. I love books, films and anything slightly creative with a to-do list of mini crafty projects getting longer by the day. I live for my friends & family, love walking the dog on the rare occasions the rain clouds disappear to reveal blue skies and I'm happiest when I'm snuggled up in front of the fire in my pj's.
1 comment:
Post details here of the table and I might be able to help. You could return the MAX(time) for each username... i.e. do a SELECT query for each username - looping through a list of all usernames perhaps...
Post a Comment