Re: Rewriting subquery for old MySQL

[Dan Nelson]

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