I've made a trouble ticket interface in PHP that uses MySQL for data storage. My boss wants me to add another way to retrieve tickets.
Right now I have ways to bring up the tickets by Date, The Person who submitted the ticket, Date AND Person, and individual ticket ID.
What I need to add is a way to view a date to a date.. or span of days.
I think there is a way to do this in MySQL but it the guide on MySQL.com wasn't making much sense to me.
So what I need is basically a statement that spans dates (i.e. 08/02/2001 to 09/10/2001)
SELECT * FROM trouble_tickets WHERE ?????
Also, I should note that my date format is
mm/dd/yyyy
Thanks for any and all help!
Right now I have ways to bring up the tickets by Date, The Person who submitted the ticket, Date AND Person, and individual ticket ID.
What I need to add is a way to view a date to a date.. or span of days.
I think there is a way to do this in MySQL but it the guide on MySQL.com wasn't making much sense to me.
So what I need is basically a statement that spans dates (i.e. 08/02/2001 to 09/10/2001)
SELECT * FROM trouble_tickets WHERE ?????
Also, I should note that my date format is
mm/dd/yyyy
Thanks for any and all help!