you used to get 'on clause' errors could not find "seat_id" column. yeh i added the extra names in just to make sure, i didnt think it was nessary. but what i did do was seperate the LEFT JOIN out, as soon as i did that it fixed the errors, just a naturally labled the columns first and never reveresed the proccess. but it works, the whole script over all has very few errors, mainly the larger sql statments need a retweek for mysql 5 as for any php, not much needs changing at all. Im going to post another topic with some of the problems im having.. lol.
cheers, chris