Hi everybody!

I got a big problem with this...
I have this 2 queries ($query1 and $query2):

$query1 = "SELECT Name, Autor, Typ, Dateiname FROM dokumente
WHERE ";
$i = 0;
while ($i<$number) //while there are still array elements to go
{
$query1 .= "$searchtype LIKE '%$splitsearchterm[$i]%' AND ";

$i++; //increment $i
}

#remove the extra " AND" from the end
$query1 = substr($query1,0,-4);

$query2 = "SELECT at.Arbeitsname, ut.Name, at.Type, at.filename
FROM users_table ut, arbeiten_table at
WHERE at.AuthorID=ut.ID AND ";
if ($searchtype==Name)
{
$searchtype=Arbeitsname;
}

else
{
$searchtype=Name;
}

$i = 0;
while ($i<$number) //while there are still array elements to go
{
$query2 .= "$searchtype LIKE '%$splitsearchterm[$i]%' AND ";

$i++; //increment $i
}

#remove the extra " AND" from the end
$query2 = substr($query2,0,-4);

Then I made a UNION of them in mysql 4.x like this and it worked:

$query = "($query1)
UNION
($query2)
ORDER BY Name";

Now I have to change the script for mysql 3.x and I wanted to use the temprary table trick like this:

$query = "CREATE TEMPORARY TABLE temp_union ".$query1."
INSERT INTO temp_union ".$query2."
SELECT * FROM temp_union ORDER BY Name";
DROP TABLE temp_union";

and it didn't work. This is the echo of the query and the error that I get:

CREATE TEMPORARY TABLE temp_union SELECT Name, Autor, Typ, Dateiname FROM dokumente WHERE Name LIKE '%cad%' INSERT INTO temp_union SELECT at.Arbeitsname, ut.Name, at.Type, at.filename FROM users_table ut, arbeiten_table at WHERE at.AuthorID=ut.ID AND Arbeitsname LIKE '%cad%' SELECT * FROM temp_union ORDER BY Name
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /vdsk/projekte.d/DET-wissdb/dokumenten_suche1.php on line 100

Can someone please tell what is wrong with the query?
Why doesn't it work?
Is there any other solution for this?
Thanx for everything!

Greetings,

Nacho.

You may use ; or \g to separate your query