[thelist] Iterate through result set - Is this possible? (SQL)

[Phil Turmel]

Joshua Olson wrote:
>>-----Original Message-----
>>From: Phil Turmel
>>Sent: Tuesday, May 31, 2005 1:14 PM
> 
> 
> 
>>TESTED on MySQL 5 w/ $hall = 2, $gapneeded = 7, and the data posted
>>earlier... (had to fix some typos and add ticks to events, before, and
>>after)
>>
>>Returned:
>>
>>gapstart 	gapsize
>>2005-06-11	17
>>
>>Comments?
> 
> 
> Phil,
> 
> I don't have immediate access to MySQL 5, and I was wondering if you
> wouldn't mind adding one thing...
> 
> Add a new event from 6-12 to 6-24 and put that event into hall 2.
> 
> What does the code return now?  
> 
Returned no rows for $gapneeded = 7,
For $gapneeded=1, it returns this:

gapstart	gapsize
2005-06-06	2
2005-06-25	3

Phil