Image

Imageholographic wrote in Imagephp

Listens: Orbital - Chime (live at Glastonbury 1994)

this may well something incredibly simple, but bear with me as my php/mysql knowledge is fairly rusty at the moment..

I've got a database that stores details of gigs - date, venue etc. the date is stored as a timestamp

I want to be able to select all gigs from a given year. I can get the date part of the year from the timestamp, but I can't figure out what mysql query to run to select only the gigs I want.
I could pull everything from the database then use a few ifs to only display gigs in that year, but that seems like a bit of overkill

any suggestions?