Re: How make the time

select count(*) from test1 where MINUTE(tm1) >= 15 and MINUTE(tm1) <= 30 and HOUR(tm1)=12 this query will return you on column containing how many record found in that time range, same as how many customers where surfed at that time where 30-15=interval and 12 is the hour you're checking in! "David Tandberg-Johansen" <david@datajo.no> wrote in message news:20010717233605.94548.qmail@pb1.pair.com... > Hello! > > I am trying to make an online booking script for a client (restaurant), and > I am using MySQL to store the booking information > The restaurant have openings hour from 11:00 -> 01:00, but do only take > reservation between 11:00->22:30. > The client wants to get a report written out over each hour like this: > > 11:00 2 Customers > 11:15 32 Customers > 11:30 12 Customers > ... > ... > 22:30 14 Customers > > In the MySQL table I have set up the time field as 'time' with 00:00:00 as > default. > > Everything is ok, but I am stuck on how to make this report. The customer > have set an interval of 15 mnutes between possible time to book, so I have > to make an 'SELECT'-query based on when the restaurant opens to the time of > the last possible booking time. But how do I make the timeset (11:00:00 and > up to 22:30:00) > > My far out example: > interval = 15; > while (time<=endtime){ > time=starttime > DBCONNECTION > Select * from booking wher tine_field='time' > time = time+interval > } > > Do anyone have any tips on how I can solve this > > David > >