chrisjenx

havent started a new thread yet mate. i'll let you know where and when

there is a differnce tho? i though left join will query all the records where as join will only return matching results if you get what i mean?

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

the mkdir error as you prob read is if you have tried to install it more than once it would create the directory, just delete the folders inside include/tmp/* its the way the querys were previosly written. for example this is how ive rewritten one: $query="select * from Seat LEFT JOIN Discount ON Seat.seat_discount_id=Discount.discount_id LEFT JOIN Event ON Seat.seat_event_id=Event.event_id LEFT JOIN Category ON Seat.seat_category_id=Category.category_id LEFT JOIN PlaceMapZone ON Seat.seat_zone_id=PlaceMapZone.pmz_id WHERE Seat.seat_order_id='".$order_id."' AND Event.event_organizer_id='$_SHOP->organizer_id'"; Where as it used to be written... $query="select * from Seat LEFT JOIN Discount ON seat_discount_id=discount_id, Event,Category LEFT JOIN PlaceMapZone ON seat_zone_id=pmz_id where seat_order_id='".$order_id."' AND seat_event_id=event_id AND seat_category_id= category_id and event_organizer_id='$_SHOP->organizer_id'"; which is messy and kept or bring back errors.

sorry i wasnt really posting a problem more making a statement If i have anyproblems i'll be sure to post my own thread didnt mean to offend anyone i'll try and help with this script as much as possible as its something I am currently working on. I havented edited the install file accept to let it ignore requiring php4, what i have noticed is not that there is a problem with the php being out of date, you will have to update alot of the MySQL satements as they... well dont work mysql5 nor php5.

Do not feel alone on this problem I have been working on this script for the past few months to bring it uptodate. and i keep finding more and more problems with it as i go along. The biggest of all being th gay smarty system, its hard enough trying follow whats going on with out trying to learn how the smarty system works. currently the only thing that doesnt work for me is payments. apart from that its all Fab! Do you want to have a copy of my code?