Sum 2 Query

[alirezaok]

I want if results count of (1) query < 40 then add results of (2) query to results of (1) query.

(1)
$Query1 = "SELECT * FROM $D1 WHERE (fname LIKE '$T1%') limit 40";

(2)
$Query2 = "SELECT * FROM $D1 WHERE (fname LIKE '%$T1%') limit 40";

(in other mean how i know count of a query and how sum 2 query?)

what do i do?

[crimaniak]

Like this:

SELECT ,1 as qNumber FROM $D1 WHERE (fname LIKE '$T1%') limit 40
union
SELECT ,2 as qNumber FROM $D1 WHERE (fname LIKE '%$T1%') limit 40
ORDER BY Qnumber