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?
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?
