brissy_matty Posted June 8, 2007 Share Posted June 8, 2007 Hi All, I have a question im a little stuck on:- What i have is a database which contains a whole lot of movie session information. This includes the following fields - Date, Time, Movie Name, Location What i am hoping to achieve is an output similar to below (formatting isnt important) but i am stuck on the query i should be using in PHP to make this happen. I think i can achive it by having mutiple loops and loops within loops - however i am aldo thinking there is a much better solution. Remembering that a movie may be in the database like 60 times with exactly the same name just different dates and times - i only need it to extract the specific movie based upon its name and i only want to display the results from a specific location. I have no problems getting just the session times from one location based on one movie on one day. But when i want to show the results like below im majorly confused - if someone could point me in the right direction - or to a good tutorial which may be helpful it would be greatly appreaciated. ================== EXAMPLE OUTPUT BELOW ====================== PIRATES OF THE CARIBBEAN: AT WORLDS END Thursday 6th June 10:00AM 11:00AM 12:00PM 1:00PM 2:00PM Friday 7th June 11:00AM 12:00PM 3:00PM Saturday 8th June 4:00PM 5:00PM 6:00PM ======================= END OF EXAMPLE ===================== Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.