i want to pass a part of query as parameter in my main query…
the code is-> $query= SELECT field1,field2,field3,field4,field5,field6,field7
FROM table1
JOIN table2 ON table1.as=table2.as
join table3 ON table3.id =table2.id
join table4 ON table4.num=table3.num
where
order by table1.state=?
AND CAST(table2.date, AS DATE)
between ?
AND ?
AND ?
order by field4;
at last ? i put a Query as parameter bt it can’t fatch result…
I don’t think this is possible.