Re: Rewriting subquery for old MySQL - SOLVED - correction!

2005-12-06 Thread Alex Gemmell
Alex Gemmell wrote: > Thanks Micheal - yeah, I managed to figure out the CREATE_TMP_TABLE privilage problem myself. I should have used those "die on errors" too - will do next time! To recap here's the working final solution (after MySQL User has CREATE_TMP_TABLES and DROP privilages): [PHP

Re: Rewriting subquery for old MySQL - SOLVED

2005-11-30 Thread Alex Gemmell
Michael Stassen wrote: Alex Gemmell wrote: Thanks Shawn but I couldn't seem to get this to work. I made the point of checking the MySQL User that PHP connects with. I gave it CREATE and DROP privilages on the database schema in question. It previously only had SELECT privilages. From