Re: Help with mysql query, multiple list

2009-05-08 Thread Abhishek Pratap
tart3 and end <= end3 > > > On Fri, May 8, 2009 at 11:26 AM, Abhishek Pratap > wrote: > >> Hi All >> >> I am kind of stuck with this query , cant expand my thinking. May this is >> a >> limitation. Here it is >> >> I have a database wi

Re: Help with mysql query, multiple list

2009-05-08 Thread Abhishek Pratap
ct ... from ... where 1 = 0" > for (i = 0; i < timestamps.length; i++) { > sql += " or start <=" + timestamps[i] + " and end >= " + timestamps[i] > } > > You'll want to use bind parameters in real life, of course. > > cheers, > barneyb >

Help with mysql query, multiple list

2009-05-08 Thread Abhishek Pratap
Hi All I am kind of stuck with this query , cant expand my thinking. May this is a limitation. Here it is I have a database with many cols two of which are start and end position for an event. Now I have a list of event time stamps, I want to find all the info once the current event time stamp