Greetings, I've been trying to work out a query for this project and I'm finally at the end of my rope. Basically, I have a ticket sales app. There is a table that has row_num and seat_num and seat_status. What I need to do is retrieve X number of seats that are sequential. For example, if someone requests 4 seats, and seats 1 and 2 are sold, he would get seats 3, 4, 5, 6. Or if seats 5, 6 are sold he would get 7, 8, 9, 10.
I'm not sure if a query is the right way to do this as I'm sure it'll increase the server load quite a bit. If anyone has an idea or could point me in the right direction, I'd appreciate it. Thanks! Kilroy __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
