From: Dan Nelson
Date: November 30 2005 4:26pm
Subject: Re: Rewriting subquery for old MySQL
List-Archive: http://lists.mysql.com/mysql/192339
Message-Id: <20051130162631.GF54383@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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']."'
> 	ORDER BY Date DESC LIMIT 10;";
> mysql_query($query1);
> 
> query2 = "SELECT * FROM tmpSubquery ORDER BY Date ASC;";
> $result_activities = mysql_query($query2);
> 
> query3 = "DROP TEMPORARY TABLE tmpSubquery;";
> mysql_query($query3);
> [/PHP]

How do you know it didn't work?  What error message are you getting?

-- 
	Dan Nelson
	dnelson@stripped