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
Hi,
Unfortunately I need to use a query on an old MySQL (4.0.xx) and the one
I currently have uses a subquery. So it works on my 4.1 but not with
this 4.0. I have read in the MySQL manual that I can rewrite subqueries
using joins but I don't see how with this query because I only have one
[EMAIL PROTECTED] wrote:
Alex Gemmell [EMAIL PROTECTED] wrote on 11/30/2005 10:06:09 AM:
Hi,
Unfortunately I need to use a query on an old MySQL (4.0.xx) and the one
I currently have uses a subquery. So it works on my 4.1 but not with
this 4.0. I have read in the MySQL manual that I
Dan Nelson wrote:
In the last episode (Nov 30), Alex Gemmell said:
I tried splitting up the queries to see if it helped but it didn't
work either:
[PHP]
$query1 = CREATE TEMPORARY TABLE tmpSubquery
SELECT * FROM tblactivities
WHERE Assignment_ID='.$row['Assignment_ID
rouvas wrote:
On Wednesday 30 November 2005 18:11, Alex Gemmell wrote:
[EMAIL PROTECTED] wrote:
Alex Gemmell [EMAIL PROTECTED] wrote on 11/30/2005 10:06:09 AM:
Hi,
Unfortunately I need to use a query on an old MySQL (4.0.xx) and the one
I currently have uses a subquery. So it works
Michael Stassen wrote:
Alex Gemmell wrote:
snip
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