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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
